Answered by:
Sync Table with different structure

Question
-
HI,
I am new to Sync. I know how two sync two table with different names and having different column name.
But my issue is that i have a table structure like following.
Data base name Server
Table name user
Column name = id,name,city, country.
Data base name Client
Table name user
Column name = id,name.
Table name address
column name = id, city, country.
Please suggest how to sync these two databases.
Thanks & Regards
Madhusudan Gupta
Friday, June 22, 2012 1:19 PM
Answers
-
that's not what sync fx was designed for.
depends on your sync direction, but that requires a lot of workaround hacks to get that working. if you still can, its easier to merge those tables into one or break apart the other one.
- Marked as answer by madhusudan21 Monday, June 25, 2012 9:12 AM
Monday, June 25, 2012 6:26 AM
All replies
-
you can sync tables having different names or columns, see: <class="entry-title"></class="entry-title">Part 4 – Synchronizing Tables With Different Table Names and Column Names
but what you're trying is synching one table to two different tables. sync framework change tracking is at the table level.
Monday, June 25, 2012 1:47 AM -
Thanks June,
Is there a work around for this?
Thanks & Regards
Madhusudan Gupta
Monday, June 25, 2012 6:16 AM -
that's not what sync fx was designed for.
depends on your sync direction, but that requires a lot of workaround hacks to get that working. if you still can, its easier to merge those tables into one or break apart the other one.
- Marked as answer by madhusudan21 Monday, June 25, 2012 9:12 AM
Monday, June 25, 2012 6:26 AM -
Thanks June for post.
i am planning to hook ChangesSelected and ApplyingChanges event and then write my own sync sp.
Monday, June 25, 2012 6:31 AM