CODEWITHSUNDEEP
sql-serversql-server-2008microsoft-sync-framework
Tom Mugo
Tom Mugo

Reputation: 21

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

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

Upvotes: 0

Views: 223

Answers (1)

JuneT
JuneT

Reputation: 7860

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

Upvotes: 2

Related Questions