Solved

Transferring a SQL database

Posted on 2015-02-17
6
37 Views
Last Modified: 2015-02-19
I have SQL Express 2008 R2 with an instance called "SQLEXpress" installed on Windows XP Pro machine.

I need to replace the Windows XP machine
I have installed SQL Express 2012 on a Windows 7 Pro machine.
Created an instance called "SQLExpress"

What is the best way to transfer the SQLExpress databases from the XP machine to the 7 machine?
The Import/Export function does not transfer schema.
The generate scripts function generates a 8GB SQL file. I have tried to run using sqlcmd command line tool but fails with some syntax errors and due to the size of the file I can't open and fix.

Any advice would be greatly received.
0
Comment
Question by:antonioking
6 Comments
 
LVL 13

Accepted Solution

by:
Nakul Vachhrajani earned 500 total points
ID: 40613978
I would vouch for a simple backup/restore of the database.
0
 
LVL 13

Expert Comment

by:Nakul Vachhrajani
ID: 40613983
0
 
LVL 1

Expert Comment

by:Jelle Dedoyard
ID: 40613993
Does dettach/ attach work in express? Because then you only need to copy over the file and attach it again at the other side.
0
 
LVL 25

Expert Comment

by:Lee Savidge
ID: 40614022
Back up and restore every time. You'll need to handle any users and maintenance jobs separately as these won't transfer that way.
0
 

Author Closing Comment

by:antonioking
ID: 40618736
Thanks, backup and restore worked a treat - feel stupid now for not thinking of this myself!
0

Featured Post

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

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

The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.

790 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