«
»

SQL Management Studio 2008 Import/Export Data (Replacement for DTS)

The old SQL Enterprise Manager used to have something called Data Transfer Services, which allowed you to transfer data between SQL Server and a different database using ODBC.  This was curiously lacking in SQL Server Management Studio 2005 (at least the Express one) unless I missed it.

However, in the 2008 version, you can right click on a database, select All Tasks and there are options for Import Data and Export Data, which open an appropriate wizard to guide you through the process.

Related posts:

  1. Error when using SQL Management Studio 2008 in Windows 7 x64 with Vault Installed I have been using my new Windows 7 machine for...

Tags: , , , , , , ,

This entry was posted on Wednesday, July 1st, 2009 at 9:07 am and is filed under Uncategorized. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

Leave a Reply