Microsoft SQL Server: SQL Server 2005 Express Edition , DTS , Data Import/Export

How to Import/Export Data in SQL Server 2005 Express Edition

At first glance it may seem that SQL Server 2005 Express edition is missing one essential feature: DTS. However, it is there. Hidden as it may be.

Added on 21 Aug 2008

General Solutions:

Solution Summary:

You can find the DTS Wizard as a separate application in Program Files.

Solution Details:

Navigate to:

Program Files / Microsoft SQL Server / 90 / DTS / Binn

There you should find the DTSWizard executable file. Double-click on it, and use the Wizard to transfer data.

Was this solution useful? Yes No

Added on 21 Aug 2008

Rating:

Solution Summary:

The above works great for copying tables of data and views, but how about the stored procedures and user defined functions? This is done within the Microsoft SQL Server Management Studio Express console by "Generating Scripts".

Solution Details:

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... This will open up the Script Wizard, which is pretty much self-explanatory:
- Select the database (which should be pre-selected for you),
- Select Options (first time around you might just accept the default selections),
- Choose the Object Types you want to script (Stored Procedures, User Defined Functions, etc),
- Select the specific objects to be scripted,
- and finally specify where to output the script (choose Script to new Query Window for convenience).
Once completed, return to the Query Window with the scripted objects. Change the USE directive (the first line) to point to the destination database (e.g., USE [Northwind]), and execute the script.

Was this solution useful? Yes No

Added on 21 Aug 2008

Rating: