Synchronizing two SQL tables

Question

Hi everyone,

I am trying to find a good solution to synchronize two tables on different SQL servers (SQL Server 2005 Express editions). I noticed that using Microsoft Sync Framework should be the easiest and most efficient way of doing it, but I cannot make it work... Can someone please provide a simple solution of how to do it? Thanks!

Ben Arthur · Answer

What I mean is to update data in TableA on SqlServer1 from identical TableA on SqlServer2 using C# code. I am writing a C# tool. The thing is I have few of ideas how to do it, but would like to find the most efficient one. I was wondering how to use Sync Framework to do this?

Sam Hobbs · Answer

What do you mean by synchronize? Do you need to apply the changes of just one of the tables to just the other table or do you need to apply the changes to both tables to each of the other table? I am not as experienced with SQL as many others but you could make a temporary copy of one table into the other server and then apply updates to the one table and if you need to also update changes to the other table then you could generate a file with updates to be applied to the other table. Or you could copy both tables to a database for temporary use, then synchronize, then copy each of the two tables back. You would need to have a way to ensure that the tables are not updated during the operation. In the worst case, you could write a simple program that opens each of the two tables using two different connections and then write the sychronization yourself. As far as I know, it is not possible to create one connection that uses two tables, each from different servers.