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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-06-17 : 08:13:33
|
| G. Levine writes "Hello.Here is my scenario:SERVER1 has a DB and SERVER two has the same DB. I want to replicate data between the two DB's and I need either DB to be able to perform and update, insert, delete and have it appear in the other.Is this possible in SQL Server? (I have done multi-master DB replication in another DBMS, but not sure if SQL Server can do this.)Regards,Greg" |
|
|
sajohnstone@advancedsoftware.co.uk
Starting Member
1 Post |
Posted - 2003-07-01 : 07:58:19
|
| I'm kinda new to this replication stuff too, and I'm trying to do exactly the same thing.Yes you can do what you're trying to do provided that you have UnqID's on all your tables and no Identity fields.I got it to work by setting up Merged replication, then setting up a Push Publisher on one server. Then run the snapshot (under the Replication agent section), and then run sycronise the Push Publisher.Thats it just schedule it to run say evey few mins... and it will keep both server's in sync.PS If you've allready found a better way please let me know. |
 |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2003-07-01 : 13:08:38
|
| What happens if the same data is updated at the same instance on both boxes? Who would you want to "win"?Brett8-) |
|
|
|
|
|
|
SQL 2000 Two-Way Replication