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.

Is it possible to set up transitional replication between a SQL Server 2005 and a SQL Azure database?

My server is nearing end of life and I would rather migrate to a cloud infrastructure instead of buying new hardware.

I’ve been unable to find any documentation stating whether or not SQL Azure Data Sync can co-exist with SQL Server Replication.

share|improve this question

migrated from serverfault.com Feb 13 '13 at 18:12

This question came from our site for professional system and network administrators.

1 Answer 1

up vote 2 down vote accepted

I'm not sure about the core of your question ("Can you set up replication between SQL Server 2005 and SQL Azure Database?"), but my assumption is a resounding "NO".

There are tools to migrate from SQL Server to Azure though - it's been discussed on Stack Overflow here and here.
The consensus seems to be that This SQL Azure Migration Wizard (CodePlex hosted project) is the way to go. It doesn't appear to be a live-sync migration though, so you will probably need to take an outage window unless I'm missing something...

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.