News & Events

SQL Server Data Migration Backward Compatibility

There may come a situation where by upgrading a SQL Server Database, you would need to roll back and restore that Database to an Instance that is of a lower/previous version.

Unfortunately this cannot be done using the traditional backup and restore methods.

Even if there was an attempt to change the compatibility level of the Database to the level you want to rollback to for the target Instance. This will also fail, as the compatibility level of the Database will not change the build number of the SQL Server Instance.

This is because unfortunatley you can only restore a Database from an Instance that has an Instance build number lower than the target Instance. This is also the case for migrating a SQL Server 2008 R2 Database into a SQL Server 2008 Instance.

However there are a number of migration tools on the market and workarounds, to migrate a Database from a higher Instance version to a target lower version. There are a few important things to remember when using one of these alternative techniques.

– There are some data types that are not compatible with this type of migration. You need to be ready to map these data types with a workaround.

– Another issue would be looking at the foreign key constraints; this can cause issues if the tables are not migrated in a particular order. The alternative would be to script out the constraints and script them back in after the migration is complete.

For more information on SQL Server Consultancy please do not hesitate to contact dsp

Get in touch

For more information or to schedule a demo please contact us

Contact us


dsp drives up its share of the Database MSP Market with
record contract growth and 2nd acquisition

DSP firmly established itself as one of the UK’s fastest growing proactive Database MSPs during 2016, signing £2.1m of new contracts and making its second acquisition, the Oracle DBA support division of IT Services provider ITSB.

Read more
View All


Applications on Oracle Database Appliance (ODA)

A main goal... how to future proof your applications environment through Oracle while becoming more efficient in terms of costs and productivity.

As well as the option of developing the fundamental steps you need to take to get ...

Read more
View All


How can you regularly benchmark your database and application infrastructure against real-life? Why would you want to?

In the age of big data, public cloud, private cloud it’s easy to be pushed into constantly thinking about the future... What should you optimise though and how can you be sure it’ll make a difference? Would knowing it could give you a competitive edge be worth considering?

Read more
View All