patternsqlModerate
Converting a SQL Server 2000 Database to SQL Server 2016
Viewed 0 times
2000sqldatabaseserverconverting2016
Problem
I need to restore a SQL Server 2000 database to SQL Server 2016. Is there any possible way to do this without having to install a complete copy of SQL Server 2008, restore to 2008, change the compatibility level and then restore the 2008 backup to 2016? I know this would work but I really don't want to install 2008 R2 just for this single purpose unless I have no other choice.
Solution
It is NOT possible to restore a SQL Server 2000 database to SQL Server 2016 without restoring it to 2008 R2 first.
Here is an answer by Aaron Bertrand with details on alternate options to get the data out of the SQL 2000 database https://dba.stackexchange.com/a/99340/60898.
Here is an answer by Aaron Bertrand with details on alternate options to get the data out of the SQL 2000 database https://dba.stackexchange.com/a/99340/60898.
Context
StackExchange Database Administrators Q#166205, answer score: 10
Revisions (0)
No revisions yet.