CODEWITHSUNDEEP
sqlsql-server-2008visual-studio-2013sql-server-2012
Muhammad Nasir Khan
Muhammad Nasir Khan

Reputation: 59

How to import Sql Server 2008 database into sql server 2012

My problem is I am working on a project and its database is created in SQL Server 2008. But I has SQL SERVER 2012 installed in my PC. I cannot import this file into my sql server and also cannot connect this database file with visual studio 2013 Help me please

Upvotes: 0

Views: 3276

Answers (1)

SchmitzIT
SchmitzIT

Reputation: 9552

The easiest way is creating a database backup in 2008, and restoring that into 2012. Should work without any issues, and the restore process will automatically upgrade the database to 2012.

Alternatively, it should also be possible to detach the database from 2008, after which you can copy the files (Do not move them, but copy. That way if anything goes wrong, you have a fallback option). You should then be able to attach it in 2012, which again, will convert the database to 2012.

There's also an option of using the copy database wizard from inside SSMS, which also converts the database.

Please note that if you convert the database, from that moment onwards, all other developers will have to upgrade to 2012 as well.

Upvotes: 3

Related Questions