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 |
|
mik706
Starting Member
1 Post |
 Posted - 2003-03-04 : 09:32:55
|
| I need to configure a pair of database instance (A and B) to update the other if any change is made, i.e. if a record is inserted in a table in A the record should automatically be inserted in the corresponding table in B and visa versa. I have set up the instances with the replication publisher and subscriber but this is only a one way replication. Is it possible to set this up in a way to make it two way or do I need to use some other method for my redundancy? |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2003-03-04 : 10:12:58
|
| I imagine you'll have keys on these tables....what happens when you try to insert a row that already exists?The short answer would be triggers.Also, how would you handle deletes and updates. What if you try to update a row trhat doesn't exists because at the time a user was updating a row in a, a user in b dleeted the row?Bi-directional has a lot to think aboutBrett8-)PS Why do you need to do this? |
 |
|
|
|
|
|
Database Redundancy