title: Programmatically Synchronize two databases with C#
body: <p>I need to update existing data or insert new data from client database say <code>DB1</code> into central database say <code>DB2</code> both holding same schema and both databases reside in same machine.<br> The updates are not biderectional. I just want changes to be reflected from client(<code>DB1</code>) to server(<code>DB2</code>).<br>
  The client database(<code>DB1</code>) is nothing but the backup database(Full database backup consisting of mdf and ldf files) of <code>DB2</code>.The backup database(<code>DB1</code>) already has the modified data when synchronize.<br><br>
  <strong>So how do i do programatically using C# .NET?Can you give any example code?</strong><br>
  I googled about it and saw Microsoft Syn Framework but I don't know how to use it programmatically in C#.
  Can you help me with sample code,please?
  Sorry for my English.<br>
  Thanks in advance.</p>