Sample code for Synchronizing two databases using Service Broker

• sql server developer

  SSCarpal Tunnel

  Points: 4746

  More actions

  December 20, 2008 at 9:45 am

  #383617

  Hi All,

  Our company is trying to synchronize two of their databases using service broker. The reason for showing interest in service broker is the databases we are trying to synchronize are of different schema. What i mean is the structure of the tables in the databases is different. And one more thing is we want to get confirmation that the updates,inserts and deletes made in one database are made in the other database too..

  I hope you understand the situation.

  Can you send me a sample code for synchronizing two databases using Service Broker.

  Thanks a lot in advance!

• ps.

  One Orange Chip

  Points: 29423

  More actions

  December 20, 2008 at 10:21 am

  #915758

  Posted twice!!

  http://www.sqlservercentral.com/Forums/Topic621581-1281-1.aspx

  ---

  
  Pradeep Singh