Here’s what more than 2,500 business decision-makers around the world say.Download the report
...with the Facility Hero app in hand! Discover how you can optimize your maintenance efforts today.Learn more
Access tailored services, 24/7 self-service and expert help. Anywhere, anytime, any project.Discover now
Everything you need to know about our IoT technology backbone.Learn more
Explore our global offerings or select your country from one of our five regions.Global
Découvrez nos offres globales ou sélectionnez votre pays dans l’une de nos cinq régions.
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