Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
Sync Table with different structure RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    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

  • Question
    Sign in to vote
    0
    Sign in to vote

    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

  • Question
    Sign in to vote
    0
    Sign in to vote

    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
  • Question
    Sign in to vote
    0
    Sign in to vote

    Thanks June,

     Is there a work around for this?

    Thanks & Regards

    Madhusudan Gupta

    Monday, June 25, 2012 6:16 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    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
  • Question
    Sign in to vote
    0
    Sign in to vote

    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