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 |
|
mmahmed
Starting Member
6 Posts |
 Posted - 2003-04-10 : 04:38:55
|
| Hi peopleI have two databases (SQL Server 2000) that I would like to synchronise, but not in the traditional replication sense i.e. at midnight everyday.I have code that will insert a record in Database A but I want Database A to also insert that record into Database B and vice versa. However, if in the future, Database C is added I can make a quick change to Database A and B to say that C exists.Is this possible with SQL Server and if so, does anyone know how to do it?Cheers in advanceMosthak Ahmed |
|
|
samsekar
Constraint Violating Yak Guru
437 Posts |
Posted - 2003-04-10 : 04:53:59
|
| Merge Replication can do. But conflicts of data can occur when same records are updated in different subscribers / publishers.Any other Ideas ?Sekar~~~~Success is not a destination that you ever reach. Success is the quality of your journey. |
 |
|
|
|
|
|
Incremental Replication