CODEWITHSUNDEEP
sql-serverssmsrestore
Dimitar Stoykov
Dimitar Stoykov

Reputation: 11

Restore DBs from higher level version of SQL Server to a lower

I'm trying to restore a Databases from SQL Server 2019 to SQL Server 2017. The only way that I found in the internet and in the forum was to generate a script. Unfortunately when the file is large it got an error:

enter image description here

For smaller files it works but for large not. Can you tell me if there is another way to do that? The upgrade of SQL Server is not the best option. I also tried with import/export, attach/detach but nothing works.

Tried with generate scripts method, import/export and attach/detach.

Upvotes: 0

Views: 101

Answers (1)

goodfella
goodfella

Reputation: 193

You may try exporting .bacpac file from source and import to target db. If the database is quite big you may fall into out of memory when using SSMS and the operation will get terminated. You can use the sqlpackage utility to do the same with parameter Storage= File. Refer https://learn.microsoft.com/en-us/sql/tools/sqlpackage/sqlpackage-export?view=sql-server-ver16

Upvotes: 1

Related Questions