This forum is closed. Thank you for your contributions.

Sign in

Microsoft.com

Microsoft

Remove From My Forums

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

Question
0

Sign in to vote

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

Answers

1

Sign in to vote
When you provision the tables , you could use the GlobalName and LocalName properties on DbSyncTableProvision to map the table names. Take a look at

http://msdn.microsoft.com/en-us/library/microsoft.synchronization.data.dbsynctabledescription_members.aspx

Thanks,
Ann Tang
- Proposed as answer by Ann Tang [MSFT]Microsoft employee Thursday, April 21, 2011 7:44 PM
- Marked as answer by Edmund Omni Saturday, April 23, 2011 9:07 PM
Thursday, April 21, 2011 7:44 PM

All replies

1

Sign in to vote
When you provision the tables , you could use the GlobalName and LocalName properties on DbSyncTableProvision to map the table names. Take a look at

http://msdn.microsoft.com/en-us/library/microsoft.synchronization.data.dbsynctabledescription_members.aspx

Thanks,
Ann Tang
- Proposed as answer by Ann Tang [MSFT]Microsoft employee Thursday, April 21, 2011 7:44 PM
- Marked as answer by Edmund Omni Saturday, April 23, 2011 9:07 PM
Thursday, April 21, 2011 7:44 PM
1

Sign in to vote

You could also check out this post:

http://social.msdn.microsoft.com/Forums/en-US/syncdevdiscussions/thread/df573e88-517e-47ea-b13c-787413a7aac3
Ann Tang

Thursday, April 21, 2011 10:18 PM
0

Sign in to vote

Hi Ann,

Looks like this will solve my problem. I will be checking it out soon and let you know.

Thanks for your prompt response.

Edmund.

Friday, April 22, 2011 6:05 PM