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.

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

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

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

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://docs.microsoft.com/en-us/azure/sql-database/sql-database-cloud-migrate

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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