Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

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!

share|improve this question

migrated from stackoverflow.com Oct 9 '13 at 3:20

This question came from our site for professional and enthusiast programmers.

2 Answers 2

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.

share|improve this answer
    
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 –  lachama Oct 25 '13 at 14:21

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

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.