Please advice what would be the best process to copy database from 2003 to 2016. Export import data wizard failed and generating the script was not successful
Please advice what would be the best process to copy database from 2003 to 2016. Export import data wizard failed and generating the script was not successful
Hi @SahaSaha-5270,
Just checking in to see if the answer(s) helped.
If an answer is helpful, please "Accept answer" or "Up-Vote" for the same which might be beneficial to other community members reading this thread.
And If you have further questions or issues please let us know.
Hi @SahaSaha-5270,
There is no SQL server 2003. Please using select @@version to check your SQL server version.
There are several ways to copy a database:
•Using the Copy Database Wizard
•Back and restore databases
Refer to MS document Copy Databases to Other Servers to get more.
Please notice the database compatibility, when you restore a database to a newer version. Refer to ALTER DATABASE (Transact-SQL) Compatibility Level.
If the response is helpful, please click "Accept Answer" and upvote it, as this could help other community members looking for similar thread.
Hi @SahaSaha-5270,
Did you check the MS document DATABASE Compatibility Level that I mentioned above? If you want to copy database from SQL 2000 to SQL 2016, suggest you to copy database from SQL 2000 to SQL 2008 , then copy SQL 2008 database to SQL 2016. We can not migrate database from SQL 2000 to SQL 2016 directly. 
you are right it Microsoft SQL Server 2000
You can not migrate a database from version 2000 directly to 2016, that's not possible, you have to make a intermediate step over an other version, e.g. migrate path 2000 => 2008 R2 => 2016
15 people are following this question.