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
|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.|
|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.|