Backup 2014 and restore to 2012
dadams63
Posts: 1 New member
in SQL Backup
Is there any tool from RedGate that would provide a way to backup 2014 and restore to 2012.
Best Answer
-
kevriley
Posts: 129 Gold 1
No. Not 'backup and restore', as you cannot downgrade a database to a lower version.
What you could do with Redgate tools though is use SQL Compare from the 2014 database to an empty 2012 database - this would generate the script(s) necessary to create the schema; and then SQL Data Compare to fill the tables.
