How to Synchronise between two tables with the same schema but different Table names RRS feed

  • Question

  • Hi,

    I have Transaction tables in remote locations which have an identity column as part of the PK.  Rather than re-architect the Remote apps, I have decided that I will attempt to synchronise each location into a newly named table.  As an example if I have a table named tblTransactions in remote location it would be synced with a table named tblTransLoc1 in Head Office and tblTransactions in location 2 would be synced with tblTransLoc2 at HeadOffice.  A separate app would combine the synced tables based on our own business logic.  As I will be using SQL Azure to store the Transaction tables for the Head Office, I do not want to create separate databases for each location.

    Is this synchronisation possible? 

    Thanks in advance. 

    Thursday, April 21, 2011 4:58 PM


All replies