Migrated 500 GB 2012 Databases into 2016 SQL Server. Now client is asking to revert to 2012. How ?
Answer by Kev Riley ·
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?