updates Not Pushed from SQL Server 2008 to SQL CE 3.5 using Microsoft Sync
-
Thursday, January 10, 2013 3:18 PM
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
All Replies
-
Friday, January 11, 2013 7:44 AM
http://social.msdn.microsoft.com/Forums/en/syncdevdiscussions/threads
ask Sync frame issue there

