I did find a mention on stack overflow that suggests using a separate sync key. It doesn't mention GUIDS http://stackoverflow.com/questions/7184372/how-do-you-sync-databases-using-m s-sync-framework-when-tables-are-using-identity
What data type would you use to store guids in the database? _____ From: [email protected] [mailto:[email protected]] On Behalf Of Greg Kennedy Sent: Thursday, 2 February 2012 11:08 AM To: ozDotNet Subject: Re: Making an application that uses identity keys occassionallyconnected I think the sync framework will crack a fruity if the Guid is not the PK. On Thu, Feb 2, 2012 at 8:50 AM, Greg Keogh <[email protected]> wrote: Kirsten has lots of tables already created with traditional PK IDENTITY columns, so I'm guessing that converting the PKs would be a nightmare. Perhaps a compromise is the answer: add an indexed Guid column to those tables that might find it useful in sync processing. That Guid is effectively "stamped" onto the row and never changes even if the INT PK does. I did this years ago to some of my own tables and they're still in use and the Guids are used by external applications to reliably and unambiguously find rows. However, can Sync Framework make use of Guid columns that are not the actual PK? Greg
