Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Tharindu
Starting Member
5 Posts |
 Posted - 2006-09-09 : 03:50:28
|
I have 2 servers using same database,Example: SERVER1\MSDN and SERVER2\MSDNI need to update msdn database customer table. When I add 1 customer server1, msdn databases then same customer have to automatically update server2 msdn database customer table. Is that possible to do that using sql server Replication? How can I do that?I need to do that with out using sp, triggers... Tharindu |
|
|
anilkdanta
Starting Member
25 Posts |
Posted - 2006-09-09 : 07:28:56
|
| Hi,You can use Replication. But do you think its not a simple thing for implementation. I am not sure how big is your database and for what kind of business is the database used. And how frequently the database hit with insert, delete, update. Do you really think Replication architecture is required ?If not you can go with Triggers, DTS package, Schduled Job running hoursly, daily what ever you think sufficient.I sugggest you to read the online help on Replication to know if this solution is feasible for your database. |
 |
|
|
Tharindu
Starting Member
5 Posts |
Posted - 2006-09-12 : 04:31:53
|
| Thanks for reply my post. Can u place send method set replication between 2 servers (example nothwind database?) thanks.Tharindu |
|
|
|
Luis Martin
Yak Posting Veteran
54 Posts |
Posted - 2006-09-12 : 11:04:19
|
| I suggest to read BOL for that, or find some article. Is not so easy to explain in one post. |
|
|
|
|
|
|
using sql server how can i do that?