Bi-directional synchronization between local SQL Server 2005 and a SQL Azure using SQL Data Sync
First: synchronize 1 table from Azure to Sql Server. Second: Execute some Store procedures in the SQL Server 2005 instance. And third: Synchronize various tables from Sql Server to Azure sequentially.


You can use the Azure data sync, but its buggy - since I never managed to get it running flawlessly for even a week. It is still in Preview mode with limitations.

Also, Data sync IMHO is suitable for database tables that deal with smaller volumes of changes per sync cycle.

If you dont want real time data sync, then I would suggest you to look into SSIS. Its much more flexible. I still use SSIS to move data from on-premise to Azure.

Alternatively, you can look into Sync Framework - Replicating, Distributing, and Synchronizing Data