Is there an easy way to revert the changes that SQL Azure Data Sync Tool does to a local database?

Question

Hi,

I tried using the SQL Azure Data Sync Tool and successfully transfered a local database from my dev machine to a SQL Azure account. However, later on I noticed that the tool has silently made a bunch of changes to my local database - definitely not a nice thing to do without any notification or confirmation dialog.

Does anybody know if there is an easy way to revert the changes(added stored procedures and tracking tables) that the sync tool has made? I know manually deleting stuff is always an option, but it's rather error prone I would consider it my last resort.

Answer 1

That sync tool is used to keep a SQL Azure database in sync with your local SQL database. The tracking tables are necessary to keep the tables in sync as the data changes. It works in a similar fashion to SQL Server Merge Replication. I am not aware of an automatic way to do that right now. Merge Replication has tools and SPROCS floating around to do this but it took a while for them to come out.

If you just want to copy a database to SQL Azure you should script it, which is easy to do with SSMS, or use some other method. The sync tool is not a good way to just copy a database.