locked
Sync Table with different structure RRS feed

  • 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