,
Migrated 500 GB 2012 Databases into 2016 SQL Server. Now client is asking to revert to 2012. How ?
asked
Migrated 500 GB 2012 Databases into 2016 SQL Server. Now client is asking to revert to 2012. How ?,I migrated a 500 GB database from SQL 2012 to SQL 2016, but client is revert back to 2012 how we revert it.
Did you take backups of the 2012 database? You can restore those and get back to the point before you migrated, but all data changes since then will be lost.
Alternatively you can script out every table, view, stored procedure, function etc from 2016 and apply them to an empty 2012 database, oh and script out all the data too. Does that sound too much? It probably does, but there is no supported downgrade path from a later version to an earlier version.
Why does the client want to go back to 2012?
Thank you @Kev Riley, To script huge database i think not possible. Is there any other method.
No, upgrade is a one way process.
you need to script the database objects, recreate them in 2012 and then transfer the data.
You should also not be using 2012 anymore even 2014 they are no longer mainstream supported.
whatever problems you encountered in 2016 go and fix them.
Your probably hit with the cardinality estimator change, look at using the legacy CE trace flags and doing a lot of query tuning.
20 People are following this question.
