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.
But after the script is generated I have to edit some of the lines of the file and here the problem arise because the files are very large and there is no editor that can open them.
I’m using the following procedure:
https://www.mssqltips.com/sqlservertip/2810/how-to-migrate-a-sql-server-database-to-a-lower-version/
I tried with the method “Generate Scripts” then import into the destination database but i have to edit some of the lines of the generated script but it’s very big file and there is no editor that can open that file for edit.
Dimitar Stoykov is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.