Sql-server – Bi-directional synchronization between local SQL Server 2005 and a SQL Azure using SQL Data Sync

azure-sql-databasesql serversql-server-2005

I need to synchronize an Sql Server 2005 database in an SQL Azure database. In other posts I've read that I can do this using Sql Data Sync but I don't know if SQL Data Sync can make the synchronizations that I need without exceeding their limitations. This is the exact process I need to do:
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.

Thanks!

Best Answer

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

Related Question