开发者

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

I tried using the SQL Azure Data Sync Tool and successfully transfered a local database from my de开发者_如何学Pythonv 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.


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.


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.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜