Sql Server Express 10.0.1600 Moved to a Sql Server 2008 10.50.1600

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
johngrant_ksAsked:
Who is Participating?
 
johngrant_ksConnect With a Mentor Author Commented:
You can right click Database > Tasks > Generate Scripts
0
 
sachinpatil10dCommented:
Take the Backup from Sql Server Express 10.0.1600
an restore it in Sql Server 2008 10.50.1600
0
 
Metehan OzculluSQL Service ManagerCommented:
event detach attach should work without problems
0
 
Ramesh Babu VavillaCommented:
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
 
johngrant_ksAuthor Commented:
I was able to work it out myself
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.