Windows Azure SQL Data Sync (SDS) – SQL Data Sync Setup Steps for Azure MS SQL Data Sync

Azure MS SQL Data Sync turns out to be a great solution.

 

On a project I am working on, there is a need to get the Azure SQL database data synced on a schedule onto a database on the corporate network.

With SDS you can sync up, down or bi directional.

 

I did have a little issue where in one field, the int data type was marked as a non supported data type.

 

Here is the link to the steps to follow

http://msdn.microsoft.com/en-us/library/hh456371.aspx

 

 

 

Before you startBefore you begin to design and implement your synchronizations, you should be familiar with these topics. How to create a sync groupThere 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)
How to modify a sync groupYou can modify a sync group’s schema by adding/removing tables or columns in the sync group; or by altering a column’s width or data type. Details can be found by following the links.