moving sql2005 database to sql2014

Question

moving sql2005 database to sql2014

adisql

SSCrazy

Points: 2893
More actions
December 15, 2016 at 4:23 pm

#316790

Hi,
Can we directly restore sql2005 database backup on sql2014 instance ?
thanks.
December 15, 2016 at 9:52 pm

This was removed by the editor as SPAM

Viewing 11 posts - 1 through 10 (of 10 total)

You must be logged in to reply to this topic. Login to reply

Jacob Wilkins One Orange Chip Points: 27976 More actions · Answer 1

Yes.

It's only hinted at in the latest official documentation for RESTORE (the Compatibility Support section was much more explicit about this in the 2012 version of the documentation), but you could reference this for something more explicit:

http://www.sqlskills.com/blogs/paul/you-can-upgrade-from-any-version-2005-to-any-other-version/

Cheers!

EDIT: Fixed a typo.

Ed Wagner SSC Guru Points: 287026 More actions · Answer 2

I've not tried migration with these exact versions, but I've heard it works. I've tried others and it worked flawlessly.

One sure-fire way is to take a full backup and try the restore. If it works, you're in business.

Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions

adisql SSCrazy Points: 2893 More actions · Answer 3

adisql

SSCrazy

Points: 2893

December 15, 2016 at 4:54 pm

#1918312

thank you !!

rnarayana078 SSC Enthusiast Points: 113 More actions · Answer 4

I would say yes, we can restore directly to 2014 instance and compatibility remains same as 2005. we can migrate the database as well.

kevaburg SSCoach Points: 18131 More actions · Answer 5

You could also use Detach / Attach to do the migration.....

Between these versions that works well......

Charles Kincaid SSChampion Points: 13593 More actions · Answer 6

Should work OK. Try it on a test instance (you have one of course).

The compatibility level of the restored database will be at the 2005 level if I remember correctly. This might cause you issues if you try to use new features.

ATBCharles Kincaid

Sreekanth B SSCertifiable Points: 6145 More actions · Answer 7

Yes, you can restore a database from 2005 to 2014 directly. Inplace Upgrade of an Instance beyond 2 versions might not work, but restoring a database from 2005 to any 2005+ version has no limitations.

lourens.wepener Grasshopper Points: 13 More actions · Answer 8

Yes, you can restore SQL2005 database to SQL 2014 - however, when you do the compatibility will change from 90 (SQL2005) to 100 (SQL2008).

100 is the minimum compatibility for SQL 2014.

adisql SSCrazy Points: 2893 More actions · Answer 9

Thank you.. i am able to restore the sql2005 backup on sql2014 without any issues.