4

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.

Improve this question
0

2 Answers 2

Reset to default
2

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...

Improve this answer
0

Today there are two recommended methods for SQL Server:

  • Migration with downtime (SQL Server >=2005)
  • Transactional Replication (SQL Server >=2012 and Azure SQL DB >= V12)

https://learn.microsoft.com/en-us/azure/sql-database/sql-database-cloud-migrate

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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