Using a SQL server 2008R2 mdf file with SQL Server 2012 -
i'm using sql server 2012 on local machine. have old version of vs solution uses sql server 2008r2 file. old version of solution run on sql server 2012 or have install sql server 2008r2 again? thanks. you can backup database sql server 2008r2 , restore in new version (sql server 2012). sql server upgrade database automatically older version new version. compatibility level of database not changed. can change compatibility of database after restore following query : alter database yourdatabasename set compatibility_level = 110 also, if detach database , attached in new version of sql server, database upgraded new version too.