none
sync different sqlexpress databases RRS feed

  • Question

  • I have two databases to sync. Both of them are SQL Express 2008 and I'm syncing with SQLSyncProvider. My problem is that are tables in the databases that are not the same (they have different columns) and syncing is not working well.

    My ask is: It is possible change the insert stored procedure in the SQLSyncProvider?

    Friday, April 16, 2010 4:21 PM

All replies

  • yes you can. am assuming you'll have to do it on the update as well.
    Friday, April 16, 2010 5:03 PM
    Moderator
  • You could try to provisioning the two tables (from 2 different databases) with the same set of columns using provisioning API.  So when sync later happens, only those specified columns during provisioning are in sync.

    Thanks.


    Leo Zhou ------ This posting is provided "AS IS" with no warranties, and confers no rights.
    Monday, April 19, 2010 2:34 PM
    Answerer
  • This is a tricky slope and could lead to problems. Fundamental question to answer is it that the column names just differ or the entire schema is different (different # of columns, different types and different primary keys)? If its just that the schema matches and only the column names dont then you can try to supply global names to those columns to make sure they match on the wire. If its the later then you have to explain what the scenario is which is requiring sync of two completely different schemas as one.

     


    Maheshwar Jayaraman - http://blogs.msdn.com/mahjayar
    • Proposed as answer by Jandeep Wednesday, April 28, 2010 6:15 PM
    Wednesday, April 21, 2010 6:40 PM
    Moderator
  • In my scenario the entire schema is different (different # of columns and different primary keys). Is it possible to define which columns match?

    e.g.

    [Users].LastName = [Dudes].FamilyName

    or is there an other way so solve this issue? A tutorial about this toic would be great.

    Thanks
    Philipp

    Friday, July 23, 2010 10:48 AM