locked
how to handle Identity columns? RRS feed

  • Question

  • 1. I have Identity column at server.should I select that Identity coulmn too, when I select incrementalinsert from server to client
    2.when more than one user is downloaded from server to client how handle identity columns?

    actually I have the server at production.


    Thanks, Bharathi
    • Moved by Max Wang_1983 Thursday, April 21, 2011 10:50 PM forum consolidation (From:SyncFx - Microsoft Sync Framework Database Providers [ReadOnly])
    Tuesday, October 27, 2009 5:03 AM

Answers

  • Hi,

    If the identity column is not PK and is not necessary for your sync purpose, you can skip it. Otherwise, you need to maintain your own itentity column value sfor server and client to ensure they will not generate the same value.

    Thanks,
    Dong
    This posting is provided AS IS with no warranties, and confers no rights.
    Tuesday, October 27, 2009 7:00 PM
    Moderator