locked
updates Not Pushed from SQL Server 2008 to SQL CE 3.5 using Microsoft Sync RRS feed

  • Question

  • Hi

    I am using Sync frame work with Download only Option from sql server 2008 - SQL SERVER CE 3.5

    For past 2 days Sync is not updating records in  SQL CE 3.5 that was updated in sql server 2008.

    This was working previously. Stopped updating for past 2 days.

    When i try to delete SDF File and re-create it  a new sdf file is created  and i could see the records   

    My code is as below

    SyncAgent sampleSyncAgent = new SyncAgent(syncTables, false);

    SyncStatistics syncStatistics = sampleSyncAgent.Synchronize();

    IN SyncAgent  class i have code as below in the constructor    

                 this.LocalProvider = new ClientSyncProvider();
                this.RemoteProvider = new ServerSyncProvider(tablestoSync, pBatchSync);
                SyncGroup syncGroup = new SyncGroup("ABC");;

    foreach (var tables in tablestoSync )

    {

      SyncTable syncTable = new SyncTable(tables.Tablename);
                    syncTable.CreationOption = TableCreationOption.DropExistingOrCreateNewTable; //UseExistingTableOrFail; // 
                    syncTable.SyncDirection = SyncDirection.DownloadOnly;
                    syncTable.SyncGroup = syncGroup;
                    this.Configuration.SyncTables.Add(syncTable);

    }

    This   was previously working but suddenly stopped syncing. 

    • Moved by ErikEJMVP Friday, January 11, 2013 11:09 AM wrong forum
    Thursday, January 10, 2013 3:18 PM

All replies