Microsoft Sync Framework - How to reprovision a table (or entire scope) fater schema changes?

Posted by Rabbi on Stack Overflow See other posts from Stack Overflow or by Rabbi
Published on 2010-05-30T02:28:49Z Indexed on 2010/05/30 2:32 UTC
Read the original article Hit count: 530

B"H

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.

© Stack Overflow or respective owner

Related posts about sql-server

Related posts about synchronization