Sync framework 2.1 with SQL Server 2008 and SQL Server CE doesn't sync inserts and dowload all updates

0
votes

I'm using the Sync framework 2.1 with SQL Server 2008 and SQL Server CE with several clients.

I provisioned the client db and synced, then deployed that file with every client application.

Now sync doesn't seem to work correctly on all but one client. Did I need to provision the db for each client independently instead of using a copy?

This question does suggest so, please advise SyncFramework 2.1 updates & deletes do not seem to apply properly

1
sql-serversql-server-2008microsoft-sync-framework

1 Answers

2
votes

in Sync Fx, each replica has a unique id to differentiate it from the other replicas. by copying a database, you'll end up with several replicas having the same id.

so what your doing will not work. if you want use a provisioned SQL CE database to initialize other clients, generate a snapshot and deploy the snapshot.

see: How To: Provision for Synchronization Using Snapshot Initialization