CODEWITHSUNDEEP
sql-server
Mark Rabjohn
Mark Rabjohn

Reputation: 1723

Export SQL Server 2014 database (2008 compatible) in a backup file compatible with 2012

I'm a bit stuck with this scenario. My dev VM has SQL Server 2014 on it, and I've been working on a SQL Server 2008 database. The 2008 database is listed as '2008 compatible'. I now need to put this on a demo server which has an older edition of SQL Server (2012), and I find that 2008 compatible DBs don't create 2008 compatible backups (which I would have thought would be a given).

I'm actually trying to backup from SQL 2014 and recover into SQL Server 2012. How do I get a SQL Server 2008 or SQL Server 2012 compatible backup file from my 2008 compatible database?

Thanks.

Upvotes: 4

Views: 3302

Answers (1)

SidiBrah
SidiBrah

Reputation: 131

You have to script the SQL database creation, in SQL Server Management Studio :

right click on the DB -> Task -> Generate script

From there a series off dialog to choose what to generate with the SQL command creation and where, in clipboard or file (recommanded for big DB), with optionally the data as some Insert Into SQL command. To find the data option click on the "Advanced" button and search for "Type of data to script"

Upvotes: 3

Related Questions