Competition: What’s your favorite Redgate tool? Enter now.
Use SQL Data Compare to keep 2 dbs in sync
Is it possible to have SQL Data Compare keep two databases in sync where either one can be written to. Normally only one will be written to, but for software updates it will be taken offline and the second server will become the active one. When the primary server comes back up I need it to be able to get the changes made to the secondary server's db and not erase the rows like has happened to me in my current testing.
0 · Share on Twitter