SQL Server - transfer a a sql server database from one laptop to another

I have a SQL Server database created in SQL Server 2008 express on one laptop.  I want to take that database and create it on my new laptop with sql server 2012 installed.  Obviously, I want all of the table structure as well as the data.  How would i best accomplish this?
vbnetcoderAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
ZberteocConnect With a Mentor Commented:
Backup on first laptop, copy the .bak file on the new laptop, restore the database, change compatibility to SQL 2012.

Backup: http://www.youtube.com/watch?v=s5DLaR6d3k4

Restore: http://www.howtogeek.com/50354/restoring-a-sql-database-backup-using-sql-server-management-studio/

To change compatibility right click on the database after restore > Properties > Option > Compatibility level. However this step is not necessarily needed, database will work fine without it, but I think is better to take full advantage of SQL 2012.
0
 
vbnetcoderAuthor Commented:
That worked.  Thank you.
0
All Courses

From novice to tech pro — start learning today.