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