Copy database from Sqlserver 2003 to 2016

Avyayah 1,271 Reputation points
2021-09-21T22:04:46.473+00:00

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
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,267 questions
{count} votes

2 answers

Sort by: Most helpful
  1. CathyJi-MSFT 21,121 Reputation points Microsoft Vendor
    2021-09-22T01:26:53.22+00:00

    Hi @Avyayah ,

    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. Olaf Helper 42,921 Reputation points
    2021-09-22T05:22:58.43+00:00

    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

    0 comments No comments