By lachama


2013-10-09 00:22:17 8 Comments

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!

2 comments

@Kin Shah 2014-08-11 13:06:38

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

@JuneT 2013-10-09 02:02:30

Steps 1 and 3 should be fine with Data Sync. For step 2, you can't configure the service to execute something else for you, so you will have to invoke the sp yourself.

@lachama 2013-10-25 14:21:05

I tried using Sql Data Sync but says it can't be used in production environment: msdn.microsoft.com/en-us/library/… I'm trying with Sync Framework

Related Questions

Sponsored Content

2 Answered Questions

1 Answered Questions

1 Answered Questions

[SOLVED] Azure SQL Server External Data Sources

1 Answered Questions

1 Answered Questions

1 Answered Questions

[SOLVED] Window Azure SQL Server DB Backup to a local-Premise

  • 2016-02-23 14:45:07
  • Worgon
  • 308 View
  • 0 Score
  • 1 Answer
  • Tags:   sql-server backup

2 Answered Questions

[SOLVED] Workflow for SQL Server + Azure SQL development?

Sponsored Content