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.
Sql-server – Converting a SQL Server 2000 Database to SQL Server 2016
sql server
Related Question
- Sql-server – Copy data from SQL Server 2000 to SQL Server 2014 Express
- Sql-server – How to make SQL Server 2008 compatible to SQL Server 2000
- Sql-server – Converting old SQL 2000 Non-Ansi code to SQL 2012 compatible
- Sql-server – Upgrading SQL Server 2005 to 2016
- Sql-server – SQL Server 2000\2005 compatibility with Active Directory 2016
Best Answer
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.