Sql Server Express 10.0.1600 Moved to a Sql Server 2008 10.50.1600


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?

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