[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Sql Server Express 10.0.1600 Moved to a Sql Server 2008 10.50.1600

Posted on 2011-10-20
5
Medium Priority
?
2,572 Views
Last Modified: 2012-05-12
HI

I have tried to move a database i have in Sql Server Express 10.0.1600 and now i want to move this to a Sql Server 2008 10.50.1600 server.

I have tried the Data Import tools but this only brings over the Tables and Data and not the stored  procedures etc

Is there another way to do this?

thanks
0
Comment
Question by:johngrant_ks
5 Comments
 
LVL 9

Expert Comment

by:sachinpatil10d
ID: 37004705
Take the Backup from Sql Server Express 10.0.1600
an restore it in Sql Server 2008 10.50.1600
0
 
LVL 7

Expert Comment

by:mozcullu
ID: 37004832
event detach attach should work without problems
0
 
LVL 10

Expert Comment

by:Ramesh Babu Vavilla
ID: 37005245
Backup attach and detach  work , we can migrate from 10.0.1600 to r2 10.50.1600 but from r2 to sql server 2008.
0
 

Accepted Solution

by:
johngrant_ks earned 0 total points
ID: 37074399
You can right click Database > Tasks > Generate Scripts
0
 

Author Closing Comment

by:johngrant_ks
ID: 37092929
I was able to work it out myself
0

Featured Post

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

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

I have written a PowerShell script to "walk" the security structure of each SQL instance to find:         Each Login (Windows or SQL)             * Its Server Roles             * Every database to which the login is mapped             * The associated "Database User" for this …
In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
This video shows how to quickly and easily deploy an email signature for all users in Office 365 and prevent it from being added to replies and forwards. (the resulting signature is applied on the server level in Exchange Online) The email signat…
Screencast - Getting to Know the Pipeline

831 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