I migrated a Database from MSSQL 2012 to MSSQL 2019 and that's supported.
But, now i got this ingenious idea of migrating back from MSSQL 2019 to MSSQL 2012 since i made some changes in the database.
SQL 2012 Version: Microsoft SQL Server Standard (64-bit) Version 11.0.7507.2
SQL 2019 Version: Microsoft SQL Server Enterprice(64-bit) Version: 15.0.2000.5
Recovery Model: Full
Compatible Level: SQL Server 2021 (110)
Database Size: 4GB
I see there are some scripts out there but it feels like a minefield, is this a bad path maybe ?
But only works with <1GB file size.
3. Stay on 2012 - redo the correct way
Setup a new 2012 SQL server and import the old DB there, execute the changes and then import back to the old 2012 instance maybe. And does it have to be exacly the right version (11.0.7507.2) or is any version of 2012 fine?
What is your recommendation and is there any free tools or scripts that can handle a 4GB db? SSIS maybe ?
- This topic was modified 2 months ago by HA4g3n.