Sql Server Express 10.0.1600 Moved to a Sql Server 2008 10.50.1600

Posted on 2011-10-20
Last Modified: 2012-05-12

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?

Question by:johngrant_ks
    LVL 9

    Expert Comment

    Take the Backup from Sql Server Express 10.0.1600
    an restore it in Sql Server 2008 10.50.1600
    LVL 7

    Expert Comment

    event detach attach should work without problems
    LVL 10

    Expert Comment

    Backup attach and detach  work , we can migrate from 10.0.1600 to r2 10.50.1600 but from r2 to sql server 2008.

    Accepted Solution

    You can right click Database > Tasks > Generate Scripts

    Author Closing Comment

    I was able to work it out myself

    Featured Post

    Maximize Your Threat Intelligence Reporting

    Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

    Join & Write a Comment

    There have been several questions about Large Transaction Log Files in SQL Server 2008, and how to get rid of them when disk space has become critical. This article will explain how to disable full recovery and implement simple recovery that carries…
    How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
    Hi everyone! This is Experts Exchange customer support.  This quick video will show you how to change your primary email address.  If you have any questions, then please Write a Comment below!
    Internet Business Fax to Email Made Easy - With eFax Corporate (, you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…

    755 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

    Need Help in Real-Time?

    Connect with top rated Experts

    22 Experts available now in Live!

    Get 1:1 Help Now