SQL Server 2005 express: Where is Import/Export and Query Analyser?

Hot Topic

Parent Child Communication
Random Numbers again!!!
DTS into sql 2005 express edition
(newbie) Simple array - complex problem
Getting AdventureWorks sample database to work
Accessing my NotifyIcon from another Form
Java Language Conversion Assistant 3.0
Visual web ide won't activate.
int and bool confusion
datagrid

VS Express Editions

I wanna use C in VS C++ Express, is it Possible?
CreateUserWizard - how to get missing field error message to show?
Problem with maskedtextbox validation and keypress
Is there a command that I can add to my program to insure that the SQL Server is running?
system.net.mail multiple attachments
Visual Studio Package Load failure - Visual Studio Explorers and Designers Package
ToDouble compiler error
Using SQL Express 2005 over the network
How do I get my free e-books?
Problem in the Installation VB 2005 Beta 2

SQL Server 2005 express: Where is Import/Export and Query Analyser?

SQL server 2005 express

I installed this software and the seperate management tool and really liked its interface compared to SQL server 2000 developer. I'm thinking of uninstalling SQL server 2000 and going with this 2005 Express version instead.  However I couldn't find any way to import MS Access tables into the database, which you could do easily in SQL server 2000.  Also, Query Analyser if not provided.  How do I get hold of the import/export tools/wizards and Query Analyser for SQL 2005 I know there is a built in querying tool with the management console but is that as powerful and Quary Analyser

Considering I'm working on a development PC (not a production server), is it worth getting rid of SQL server 2000 for this 2005 Express version

Thanks for your help

Answer this question

SQL Server 2005 express: Where is Import/Export and Query Analyser?

  • ZaceOne

    Mike:

    is there ANY way to get a copy of this SSIS thing and incorporate it into either Web Developer Express of SQL Server Express

    regards, David Wilson.

  • Tinus Groenewald

    Management Studio incorporates the functionality of both Enterprise Manager and Query Analyzer; there is not a separate UI query tool in SQL 2005, regardless of the edition. As far as I know, the query functionality in Management Studio matches that from Query Analyzer and I don’t believe we’ve changed that in Management Studio Express.



    The Import/Export wizards are not included in SQL Express as those are part of the functionality of SSIS, which is not part of SQL Express. If you have SSIS from a different Edition of SQL Server, it will work against Express. There are a number of other options for moving data into SQL Express from Access:



    * Export the data from Access into your SQL database via ODBC
    * Use the Access Upsize wizard to move the database to SQL
    * Export the data from Access to text and use BCP to pull it into SQL
    * Create the tables in SQL, then link them into Access and use an Append query to put the data into the linked tables



    Hope this helps,

    Mike

  • SQL Server 2005 express: Where is Import/Export and Query Analyser?
Answer this question