locked
Exporting/Importing Sql Server Express 2005 DB to SQl Server 2008 RRS feed

  • Question

  • Could someone please give me instructions on how to export a DB from SQL server Express 2005 and import the same data into SQL Server 2008?

    Any help would be great!

    Wednesday, March 21, 2012 7:16 PM

Answers

  • Hi OMurphy,

    In the SQL Server 2005 Express edition you can use DTS wizard and generating scripts to export database.
    For DTS Wizard as a separate application in Program Files. Please follow the steps to add DTS WIZARD WITH SQL SERVER MANAGEMNT STUDIO EXPRESS

    1. Try "C:\Program Files\Microsoft SQL Server\90\DTS\Binn\DTSWizard.exe"
    If it worked, you already have the DTS Wizard. Start using it right away.

    2. Download the Microsoft SQL Server 2005 Express Edition Toolkit from here and select all components to install.

    3. Run "C:\Program Files\Microsoft SQL Server\90\DTS\Binn\DTSWizard.exe"

    Now you can transfer data using the the great DTS wizard.

    Follow the steps If you want to integrate it with the Sql server management studio express UI .
    1. Open sql server management studio express.
    2. Select Tools -> External Tools
    3. Add a Title and Browse C:\Program Files\Microsoft SQL Server\90 \DTS\Binn\DTSWizard.exe for the Command field.
    3. Click OK

    Alternatively the above solution  works great for copying tables of data and views, but how about the stored procedures and user defined functions? So you can try to use Microsoft SQL Server Management Studio Express console by "Generating Scripts".
    • In Microsoft SQL Server Management Studio Express, expand the databases.
    • Right-Click on the database containing objects you want to copy to another database
    • Click on Tasks, then Generate Scripts

    o Select the database (which should be pre-selected for you),
    o Select Options (first time around you might just accept the default selections),
    o Choose the Object Types you want to script (Stored Procedures, User Defined Functions, etc),
    o Select the specific objects to be scripted
    o Finally specify where to output the script (choose Script to new Query Window for convenience).

    For more information, please refer to Data import / export with SQL Server Express using DTS Wizard


    Regards, Amber zhang

    • Marked as answer by amber zhang Thursday, March 29, 2012 6:08 AM
    Friday, March 23, 2012 2:26 AM

All replies

  • Hi OMurphy,

    In the SQL Server 2005 Express edition you can use DTS wizard and generating scripts to export database.
    For DTS Wizard as a separate application in Program Files. Please follow the steps to add DTS WIZARD WITH SQL SERVER MANAGEMNT STUDIO EXPRESS

    1. Try "C:\Program Files\Microsoft SQL Server\90\DTS\Binn\DTSWizard.exe"
    If it worked, you already have the DTS Wizard. Start using it right away.

    2. Download the Microsoft SQL Server 2005 Express Edition Toolkit from here and select all components to install.

    3. Run "C:\Program Files\Microsoft SQL Server\90\DTS\Binn\DTSWizard.exe"

    Now you can transfer data using the the great DTS wizard.

    Follow the steps If you want to integrate it with the Sql server management studio express UI .
    1. Open sql server management studio express.
    2. Select Tools -> External Tools
    3. Add a Title and Browse C:\Program Files\Microsoft SQL Server\90 \DTS\Binn\DTSWizard.exe for the Command field.
    3. Click OK

    Alternatively the above solution  works great for copying tables of data and views, but how about the stored procedures and user defined functions? So you can try to use Microsoft SQL Server Management Studio Express console by "Generating Scripts".
    • In Microsoft SQL Server Management Studio Express, expand the databases.
    • Right-Click on the database containing objects you want to copy to another database
    • Click on Tasks, then Generate Scripts

    o Select the database (which should be pre-selected for you),
    o Select Options (first time around you might just accept the default selections),
    o Choose the Object Types you want to script (Stored Procedures, User Defined Functions, etc),
    o Select the specific objects to be scripted
    o Finally specify where to output the script (choose Script to new Query Window for convenience).

    For more information, please refer to Data import / export with SQL Server Express using DTS Wizard


    Regards, Amber zhang

    • Marked as answer by amber zhang Thursday, March 29, 2012 6:08 AM
    Friday, March 23, 2012 2:26 AM