we are trying to migrate the database from 2019 express edition to 2017 enterprise edition , pls suggest which POA is best , how we will do this activity without any error .

Srinivas Naraipeddi 40 Reputation points
2024-10-17T09:40:46.94+00:00

we are trying to migrate the database from 2019 express edition to 2017 enterprise edition , pls suggest which POA is best , how we will do this activity with any error .

  1. we will plan for migration through data tier application but we have one issue because here version and editions also different is it possible to migrate the database in this scenario.
  2. we have to migrate all the data like indexes and constraints and keys with table data .
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,947 questions
SQL Server Migration Assistant
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
537 questions
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. Olaf Helper 44,936 Reputation points
    2024-10-17T09:48:33.3233333+00:00

    we are trying to migrate the database from 2019 express edition to 2017 enterprise edition , pls suggest

    SQL Server databases are not backward compatible, you can not restore/attach a 2019 database to a 2017 server.

    You have to do a lot of manually work, you could e.g.


  2. CathyJi-MSFT 22,306 Reputation points Microsoft Vendor
    2024-10-18T01:47:33.8433333+00:00

    Hi @Srinivas Naraipeddi

    Full agree with others, the best choice is to upgrade SQL server to the latest version 2022.

    Quote from MS document SQL server 2017 out of mainstream support at Oct 11, 2022.

    10-18-1

    If you still want to migrate SQL server 2019 databases to SQL 2017, please follow the steps from this blog How to migrate a SQL Server database to a lower version


    If the answer is helpful, please click "Accept Answer" and kindly upvote it.


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.