Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

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

Posted on 2014-03-08
2
Medium Priority
?
714 Views
Last Modified: 2014-03-17
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?
0
Comment
Question by:vbnetcoder
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 27

Accepted Solution

by:
Zberteoc earned 2000 total points
ID: 39914748
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
 

Author Closing Comment

by:vbnetcoder
ID: 39934574
That worked.  Thank you.
0

Featured Post

Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
I have a large data set and a SSIS package. How can I load this file in multi threading?
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

618 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question