Backup 2014 and restore to 2012

Is there any tool from RedGate that would provide a way to backup 2014 and restore to 2012.

Best Answer

  • kevrileykevriley Preston, UKPosts: 121 Gold 1
    Accepted Answer
    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.
    Kevan Riley
    Riley Waterhouse Limited
    Twitter: @kevriley
Sign In or Register to comment.