![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(73.60000000000001, 79%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EST%3C/text%3E%3C/svg%3E)
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
Hi @sql test
SQL Server checks the version of the database when restoring and does not allow you to restore a database from a newer version of SQL Server to an older version of SQL Server.
However, you could use the Import/Export wizards in SSMS to migrate from 2019 to 2017.
Or an alternative: Clone the Database, using on local.
In the SSMS, right click on the database to export, then Tasks => Export Data-tier Application it creates a bacpac file.
Copy the backpac to the distant server, and there in SSMS, right click on the "Databases" folder and then Import Data-tier Application, use the copied backpac file.
It copies the schema and the data as well.
Referring from this thread: Clone a database from SQL Server 2019 to 2017
Best regards,
Cosmog Hong
If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our Documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
