Home Library Learn Samples Downloads Support Community Forums
0 out of 1 rated this helpful - Rate this topic

How To: Manually Deprovision a Database

 

SQL Azure Data Sync Icon

There may be times when you delete a database from a SQL Data Sync (Preview) sync group and the database does not fully deprovision. In such cases, you must manually deprovision the database. This topic walks you through manually deprovisioning a database after you removed it from all sync groups.

The Silverlight portal was officially decommissioned May 15, 2013. Going forward, use the Windows Azure Management portal, for Windows Azure SQL Data Sync.

You access SQL Data Sync (Preview) via the SYNC tab under SQL Database at the Windows 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:

Manually Deprovision a Database

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

WarningWarning
If you deprovision a database that is a member of more than one sync group synchronizations for all sync groups which the database is associated fail since the database is no longer provisioned.

noteNote
If your topology does not include any SQL Server databases you need to install a client agent locally to get the deprovisioning tool.

 

Usage:

DeprovisioningUtil.exe <connectionstring> [/f]

<connectionstring>

Specifies the connection string of the SQL Server database or SQL Database instance to be deprovisioned.

[/f]

Deprovision without warning.

Examples:

SQL Server

deprovisioningutil "Server=(local);
Database=NorthWind;Trusted_Connection=True

SQL Database

deprovisioningutil
"Server=tcp:rwd3dyq2ym.database.windows.net;
Database=NorthwindAzure; User ID=<yourID>;
Password=<yourPassword>;
Trusted_Connection=False;" /f

Navigation

SQL Data Sync (Preview) is a feature of SQL Database. From the Windows 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 Windows Azure Management portal. Details on each step can be found by following these links.
  1. Sign in to the Windows Azure SQL Database Management portal
    SQL Data Sync (Preview) is found as a tab under SQL Database only after you create a sync group.

  2. How To: Install a SQL Data Sync (Preview) Client Agent

  3. How To: Register a SQL Server Database with a Client Agent

  4. How To: Create your Sync Group (SDS)

  5. How To: Define your sync data (SDS)

  6. How To: Configure your sync group (SDS)

See Also

Did you find this helpful?
(1500 characters remaining)

Community Additions

ADD
© 2013 Microsoft. All rights reserved.
|
Site Feedback
© 2013 Microsoft. All rights reserved.