Re-provisioning without losing data

Question

There's any way to re-provision a local database without losing the local data, (using Sync framework 2.1) ?

My scenario is:

1. Add a new column on Remote DB
2. Re-provisioning the Remote DB (to include the new column on the synchronization template)
3. Re-provisioning the LOCAL DB.

My problems start at step 3 because I need to drop all the tables present on LOCAL DB to be able to get the new scope, otherwise I will get the Exception: "Invalid column name 'new column'"

So, it is possible to re-provision a local DB without drop the older tables ?

Please, all the help will be appreciated.

Answer 1

deprovisioning doesnt remove data, it only removes metadata/objects associated associated with a scope. If its database deprovisioning, it removes all Sync Fx created objects.

so the good side, you don't lose data. the bad side, if you reprovision a new scope on the same table, they already have data. But new scope doesnt know about these data (the sync knowledge is empty on new scopes) so you end up synching existing rows which in turn results to conflicts.

wiping one of the replicas is the quickest solution.