Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
Changed seed on tables after sync RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi all

    I have this scenario in  my app: server db sql express, client 1 db sql express, client 2 sql express. They works all offline, so in avery moment they can be synchronized.

    I have provisioned my tables with different scopes ordering them by their dependencies (first sync the parents tables then the childs in order to avoid PK conflicts).

    I noticed, in my tests, that if I insert in server a new row (the id column is autocounter) id = 1  and in client 1 another different row in the same table and unfortunately the id is set to 1, when i sync the client the two rows becomes one (the sync framework see the rows as the same). To avoid this I made a reseed in the db so the clinet 1 id will start from 1000000, the client 2 from 2000000 en so on. 

    The sync so run correctly, but i had a trouble in last sync when I made sync clinet 2 to server then sync client 1 to server, after sync all the dbs was reseeded like the client 2 (the counter of id starts from 2000000 for all dbs) and i have lost the records of client 1.

    Perhaps my architecture is not correct...

    The sync may change also the seed of db?

    Thanks

    FG.Informatico www.fgpuntoinformatico.it
    Tuesday, May 31, 2011 8:53 AM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote

    ID range management is not supported in syncFx. we would recommend you use GUID instead of the Identity column to aovid future issues with the ID range ( such as reseed, range assignments etc).

    in your case, you will need to reset seed at each clients ( and the server if the server side has INSERTs also ). you can refer to this post for detailed queries: http://social.microsoft.com/Forums/en/syncdevdiscussions/thread/175d48f6-b083-440c-bb7f-4cf8b6d6b70a

     

    thanks

    Yunwen

    This posting is provided "AS IS" with no warranties, and confers no rights.
    • Proposed as answer by Yunwen Bai Wednesday, June 1, 2011 2:35 PM
    • Marked as answer by FG.Informarico Wednesday, June 1, 2011 4:08 PM
    Wednesday, June 1, 2011 2:35 PM

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote

    ID range management is not supported in syncFx. we would recommend you use GUID instead of the Identity column to aovid future issues with the ID range ( such as reseed, range assignments etc).

    in your case, you will need to reset seed at each clients ( and the server if the server side has INSERTs also ). you can refer to this post for detailed queries: http://social.microsoft.com/Forums/en/syncdevdiscussions/thread/175d48f6-b083-440c-bb7f-4cf8b6d6b70a

     

    thanks

    Yunwen

    This posting is provided "AS IS" with no warranties, and confers no rights.
    • Proposed as answer by Yunwen Bai Wednesday, June 1, 2011 2:35 PM
    • Marked as answer by FG.Informarico Wednesday, June 1, 2011 4:08 PM
    Wednesday, June 1, 2011 2:35 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hallo Yunwen

    thankyou for your reply.Your solution is the same I thought.

    Change the id column to GUID in a relational db whith 60 tables is not simple, but I know is most elegant solution.

    I will make a reseed every time I sync the db.

     

    Thank you 

    FG.Informatico www.fgpuntoinformatico.it
    Wednesday, June 1, 2011 4:17 PM