Microsoft Sync Framework - How to reprovision a table (or entire scope) after schema changes?
- by Rabbi
I have already setup syncing with Microsoft Sync Framework, and now I need to add fields to a table.
How do I re-provision the databases?
The setup is exceedingly simple:
Two SQL Express 2008 servers
The scope includes the entire database
Using Microsoft Sync Framework 2.0
Synchronizing by direct access. Using the standard new SqlSyncProvider
Do I make the structural changes at both ends? Or do I only change one server and let Sync Framework somehow propagate the change?
Do I need to delete the _tracking tables and/or the stored procedures? How about the triggers?
Has anyone been using the Sync Framework? Please help.