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.

add comment

1 Answer 1

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
add comment

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.