philduba.com

Import/Export in SQL Server Management Studio Express

Posted On October 25, 2006 11:25 AM By Phil in SQL Server,General

After some Google searching, I found out why the Import/Export feature was not available for a database's Task menu in the new management studio: It just doesn't exist natively in the GUI. I had to upgrade to SP1 for the studio express edition, which can be found here. Once the upgrade is complete, navigate to C:\Program Files\Microsoft SQL Server\90\DTS\Binn\DTSWizard.exe. This is the import wizard we all know and love. Nice to see Microsoft give out a tool to help us get accustomed to SQL Server 2005 and not give us a tool within the GUI to migrate data.

Comments (2) | Print | Send | del.icio.us | Digg It! | Linking Blogs | 6251 Views

Related Blog Entries

• SQL Server 2005 Express and ColdFusion MX 7 (July 4, 2006)

Comments (Comment Moderation is enabled. Your comment will not appear until approved.)

Now that MS moved to SP2 for that product, there is no more DTSwizard.exe in the install. Anyone got any other ideas?

# By quinn | 3/6/07 3:14 PM

Quinn, unfortunately, it looks like they've taken that our for some tool called BCP, according to the forums on the Microsoft website.

# By Phil Duba | 3/6/07 5:55 PM

Post Your Comments

Name:

Email Address:

Website:

Comments:

Enter text that you see in the image:

Remember My Information:

Subscribe:

If you subscribe, any new posts to this thread will be sent to your email address.