SQLTeam.com | Weblogs | Forums

Replicating data between 2014 and 2005


#1

Hi

I will be installing a new database sql 2014 system, which is based on our current 2005 database system.
The new system will be on a completely new infrastructure when we go live, leaving the current infrastructure available for rollback should we encounter any issues.

The business requires that a rollback option be available for 2 weeks minimum. Therefore in the event of a disaster scenario we would be required to switch back to the 2005 database system. So the challenge I have is replicating the data upon going live with the 2014 database system.

I am looking for a way to replicate the data (not necessarily the schema) from the 2014 system to the 2005 system.

I am not really a fan of SQL Server Replication and my preference is not to use this. My understanding is that this is not an option for us anyway due to the versions being too far apart, and therefore not supported.

I want to reach out to the community to find out if any tools are available to achieve this type of replication.
It may be possible for us to implement a schema change freeze if this helps in finding the right solution.

Please can you advise what options are available to us, if any? Or should we look to develop a bespoke system internally?

Are you aware of any Microsoft partners that might achieve this for us through a solution already developed?

Thanks in advance for any advice.

Joe


#2

Though ugly, you could replicate to a 2008 R2 system and then replicate from there to 2005.