Share via

Copy database from Sqlserver 2003 to 2016

Avyayah 1,291 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.
14,492 questions

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. CathyJi-MSFT 22,396 Reputation points Microsoft External Staff
    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 47,416 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

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.