question

Subbarayudu_12_21 avatar image
Subbarayudu_12_21 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.

,

Migrated 500 GB 2012 Databases into 2016 SQL Server. Now client is asking to revert to 2012. How ?

sql-server-2012sql-server-2016
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Kev Riley avatar image
Kev Riley answered

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?

10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Subbarayudu_12_21 avatar image
Subbarayudu_12_21 answered

Thank you @Kev Riley, To script huge database i think not possible. Is there any other method.

1 comment
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

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.

0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.