0

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.

tishon
  • 650
  • 6
  • 14
  • 1
    You could reload from the backup you shot just before you ran the tool against your database. (Yeah, I always forget to do that, too.) – Bill Sep 09 '10 at 17:10
  • I made a backup and appreciate your constructive irony, Bill. – tishon Sep 10 '10 at 07:39

2 Answers2

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.

Matt Spradley
  • 7,854
  • 9
  • 31
  • 40
  • Thanks for the info, Matt. I ended up recovering from a backup, but I think the data sync tool should at least state explicitly that it will mess with the structure of your DB. – tishon Sep 10 '10 at 07:48
0

Q: How do I manually deprovision a database?

A. A standalone executable is installed with the LocalAgentSetup.msi that you can use to de-provision the SQL Data Sync objects that are created when you add a database or table to your synchronization service.

MSDN Article Here.

forsvarir
  • 10,749
  • 6
  • 46
  • 77
Nick
  • 1