Client database constraints deleted with TableCreateOptions.UseExistingTableOrFail RRS feed

  • Question

  • hi there,

    today i ran into a problem. i have some sql ce databases synchronized via WCF with an SQL Server 2008 with change tracking enabled. everything works fine except one thing.
    when CreateSchema() is called on the ClientSyncProvider, it deletes the foreign key constraints available in the database although my SyncAdapters are told to use UseExistingTableOrFail TableCreateOptions.
    The Schema on the server is somewhat different than the schema on the clients.
    is there a way to prevent the schema getting changed and use the existing schema instead?
    thanks in advance
    • Moved by Tina_Tian Friday, April 22, 2011 7:57 AM (From:SyncFx - Microsoft Sync Framework Database Providers [ReadOnly])
    Friday, October 24, 2008 12:38 PM