question

SahaSaha-5270 avatar image
0 Votes"
SahaSaha-5270 asked Cathyji-msft commented

Copy database from Sqlserver 2003 to 2016

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

sql-server-general
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

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.

0 Votes 0 ·
Cathyji-msft avatar image
0 Votes"
Cathyji-msft answered Cathyji-msft commented

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.



· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

@Cathyji-msft, yes you are right it Microsoft SQL Server 2000

0 Votes 0 ·

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.
134138-screenshot-2021-09-22-133913.jpg


0 Votes 0 ·
OlafHelper-2800 avatar image
0 Votes"
OlafHelper-2800 answered

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

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.