Remove a Database from a Sync Group
Updated: December 2, 2014
Over time, you may want to modify a SQL Data Sync (Preview) sync group. This topic walks you through removing a database from an existing sync group.
If you need to add a database to a sync group, see the topics Add a Database to your Sync Group.
The Microsoft Azure SQL Data Sync plug-in on the Microsoft Azure Silverlight portal has been decommissioned. Going forward, use the Microsoft Azure Management portal, for Azure SQL Data Sync.
You access SQL Data Sync (Preview) via the SYNC tab under SQL Database at the Microsoft Azure Management portal. The SYNC tab is only available when you have one or more sync groups. See the topic How To: Create a Sync Group (SDS) for guidance on creating and modifying a sync group from this portal.
See the Navigation section below for links to topics you should read before you start and guidance on creating and modifying sync groups.
Modifications you can make to a sync group include:
Update a Sync Group Schema
Add a Database to your Sync Group
How To: Remove a Database from a Sync Group (SDS) - this topic
Delete a Sync Group
Manually Deprovision a Database
Cancel a Synchronization
Change an Agent's Key
|Do not physically delete any database in the Sync Group before you remove it from the Sync Group. If you delete the database prior to removing it from the Sync Group it is still registered with the synchronization service and must be recreated to remove it from the Sync Group.|
For each Sync Group you want to remove a database from:
Begin at the SQL Data Sync (Preview) landing page.
To get to the SQL Data Sync (Preview) landing page:
Navigate your browser to the Azure management portal –http://manage.windowsazure.com.
Click SQL Databases.
Click the Sync (Preview) tab.
- Navigate your browser to the Azure management portal –http://manage.windowsazure.com.
From the list of sync groups and agents, click the sync group you want to remove the database from.
Click the References tab.
From the list of databases, select the database you want to remove from the sync group.
Confirm that the database was successfully removed and deprovisioned.
If a database fails to deprovision, you can deprovision the database manually.
At the Windows Start menu, type in
cmdin the Search text box and hit enter.
Navigate to the directory where you installed the client agent.
DeprovisioningUtilto deprovision the database.
Deprovisioningutil.exe <connection_string> [/f]
<connection_string>- Specifies the connection string of the SQL Server database or SQL Database instance to be deprovisioned.
[/f]- Deprovision without warning.
deprovisioningutil "Server=tcp:rwbhdyp2ym.database.windows.net; Database=NorthwindAzure; User ID=<yourID>; Password=<yourPassword>; Trusted_Connection=False;" /f
Confirm that the database was properly removed and deprovisioned.
Launch SQL Server Management Studio.
Connect to the server that hosts the database you deprovisioned.
Find the database you deprovisioned.
If this database belonged to only one sync group, ensure that there are no tables with “_dss” in the name.
If any tables with “_dss” in the name remain, use DeprovisioningUtil.exe to clean up the database. See the Manual Database Deprovisioning section above.
SQL Data Sync (Preview) is a feature of SQL Database. From the Azure Management portal you can perform all tasks necessary to create, deploy, and modify a sync group.
Before you start
Before you begin to design and implement your synchronizations, you should be familiar with these topics.
How to create a sync group
There are six steps to creating a sync group from the Azure Management portal. Details on each step can be found by following these links.
ConceptsSQL Data Sync
SQL Database Data Types supported by SQL Data Sync
Data Security in SQL Data Sync
Conflict Resolution when Synchronizing
SQL Data Sync Troubleshooting Guide
Glossary of SQL Data Sync Terms
Other ResourcesAzure Management Portal
SQL Azure Data Sync [Channel 9 videos]
SQL Data Sync Forum