Is there any tool from RedGate that would provide a way to backup 2014 and restore to 2012.
Comments
1 comment
-
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.
Add comment
Please sign in to leave a comment.