How to make Import and Export data options available for Microsoft SQL Server 2005 Express



The option to import or export data from one database to another is typically executed with the use of the Data Import/Export Wizard. The wizard is accessible within SQL Server Management Studio, or Enterprise Manager for SQL 2000, on the database properties menu under Tasks.

However, the Import/Export Data options are not listed in SQL Server 2005 Management Studio Express by default because a full standard edition of SQL Server, or better, is required for certain advanced tools, such as importing data from a separate database.

The work around is to install theMicrosoft SQL Server 2005 Express Edition Toolkit, which can be downloaded from the Microsoft Website:

The installation takes approximately 20 minutes. Afterwards, navigate to theC:\Program Files\Microsoft SQL Server\90\DTS\Binn folder and double click on the DTSWizard.exe file to open the Import/Export Wizard.

Date Created: July 14, 2009
Last Revised: July 20, 2009
Original Author: DB
All content © 1992-2009 Schneider Electric

Legacy KB System (APS) Data: RESL199413 V1.0, Originally authored by MiNe on 07/21/2009, Last Edited by MiNe on 07/21/2009
Related ranges: Database for PowerLogic Software