Removing sync automatically and manually

Question

I have tried using Azure sync to sync from local sql to Azure database.

I noticed that the sync added many tables, stored procedures and other objects to my local database.

1. How do I remove the syc from the azure management console and will this remove the objects that were created onthe local database?

2. If for some reason removing from management console fails and it is necessary to remove the local objects manually - how should I do this?

Answer 1

Hi dagi1!

the process of deleting data sync objects in the cloud is easy.. and followed yo will see all Data Sync local objects remove from your database local.

First check that Data Sync local agent is running ok in the local machine where SQL Server was. You should see all synced databases there in this agent, in your machine. This is the important thing. To chek that is ok, you should be able to connect with this agent to your local server and their databases if it's ok that's the first step.

Second, using this agent, unsuscribe SQL Server local databases with the correspondent button, connect and select database in the agent and click Unregister. You should see the message operation succeded or something like that and then you will see no more the database in the agent. This will clear your Data Sync local database tables and objects.

Once unsusbcribed, it's Azure Data Sync configuration time. Go to your Data Sync in Azure and to the databases node under Sync Groups where appear your participating databases and delete the agent linked to your data sync group (firs delete the database reference in this node).

When succeded i'ts time to delete the data sync group, if failed, there is an option to force delete in the panel with the graphical representation of databases and connections, in the main graphic area.

That process allowed us to clear all data sync synchronization information.

I hope this could help you. If so, please mark the answer as Answer or as Helpful. Otherwise please if you provide more info I'll be glad in trying to help

Regards,

---

Maick · augurarte :: Albacete · Spain : Guia practica Expression Web, Anaya Multimedia

Answer 2

you can find the detailed steps for removing a sync group or just removing specific databases in the SQL Azure Data Sync service MSDN docs here:

Remove a Sync Group

Remove a Database from a Sync Group

Answer 3

The problem is that in the management studio the databases under sync group are showing as synchronizing. This has been going on for the past few hours (even though it is not a very large database) and when I try to unregister the database from the agent it says the action cant be completed (I assume because it is currently syncing?)

Is there any way to force the sync to stop?

Answer 4

stop the agent service or change the credentials on your sql azure database... that should prevent the service from connecting to either your on-premise or cloud-based databases...

but before doing that, have a look at the logs and see if it logged any error in there.

Answer 5

The problem is that after unregistering the database from the agent, it was removed from the azure management console, but the database still shows in the agent with a state of "tombstoned" and a message that says "database has been marked for unregistration and is awaiting deprovisioning."

Answer 6

In any case assuming none of the advice works, what objects do I need to remove manually to completely remove the sync?

As far as I understand it is all tables, stored procedures and triggers with dss in the name - anything else?

Answer 7

there is a deprovisioning utility that gets installed in the same folder as the sync agent. You can use that to clean up everything. you can find the instructions in the same links above under the section: Force Removal

If u have to delete manually, in addition to triggers, sp n tracking tables, there are also user defined table types