MS SQL replication
Posted on 2011-03-03
We have a server A running SQL 2000 and we replicate data from Server A to server B (running SQL 2000 too) by transaction mode of MS SQL replication. We have application C that using data from A and application D that using data from B.
When the connection between A and B drops, the replication is stopped, C and D still work. However, when connection between A and B up again. The replication is reinitialized and it locks the data at B, so the D gets error.
Is there any settings for the replication that can help D to still use data at B while the replication is reinitializing? (We accept that data between A and B can be different at this time). Is there any third-party software can do the replication that can support this if the MS SQL is not able to?