Comparing SQL Server 2005 with SQL Server 2000 Tools

As already noted, SQL Server 2005 has improved some of the old tools and introduced a number of new tools. However, for those of you who have worked with the earlier versions of SQL Server, you may see that some of the tools no longer exist. Of course, this does not mean that the tasks and scenarios that the old tool supported have been removed from the product. To the contrary, improvements have been made to the tool or it has been integrated with another tool to increase productivity. The goal in SQL Server 2005 has been to increase productivity. One of the points of improvements has been to integrate the same experience across all SQL Server products to provide ultimate productivity. For example, Query Analyzer in SQL Server 2000 provided a good authoring experience for SQL Server 2000 Engine. However, the tool for execution of MDX queries against Analysis Services 2000 was a tool named MDX Sample Application. In SQL Server 2005, both these tools have been integrated into SQL Server Management Studio.

For those of you who were familiar with the old tool set and would like to be able to find your way through the new tool set, see Table 1.1.

Table 1-1. Relationship Between SQL Server 2000 and 2005 Tools

SQL Server 2000 Tool	SQL Server 2005 Tool
Query Analyzer	SQL Server Management Studio
Enterprise Manager	SQL Server Management Studio
SQL Profiler	SQL Server Profiler
SQL Server Agent	SQL Server Agent
Index Tuning Wizard	Database Engine Tuning Advisor
Service Manager	SQL Server Configuration Manager
Client Network Utility	SQL Server Configuration Manager
Server Network Utility	SQL Server Configuration Manager
Import and Export Data	Import and Export Data Wizard in SQL Server Management Studio
BCP	BCP
ISQL	SQLCMD
OSQL	OSQL
Analysis Manager	SQL Server Management Studio and Business Intelligence Development Studio
MDX Sample Application	SQL Server Management Studio
Reporting Services Report Manager	Reporting Services Report Manager
None	Business Intelligence Studio
None	Upgrade Advisor
None	Surface Area Configuration
None	Analysis Services Deployment Wizard
None	Report Builder
None	Reporting Services Configuration
None	Error and Usage Reporting

Analysis Manager, MDX Sample Application, Enterprise Manager, and Query Analyzer are consolidated into SQL Server Management Studio. In fact, Management Studio is an integrated and comprehensive environment for management, administration, authoring, monitoring, and development for all SQL Server 2005 products (see Figure 1-2).

Figure 1-2. Integration of legacy tools in SQL Server Management Studio.

[View full size image]

SQL Profiler has had a small name change: In SQL Server 2005 it is called SQL Server Profiler.

The Index Tuning Wizard launch point was only from Enterprise Manager in SQL Server 2000. In SQL Server 2005, it has a number of impressive features that make it a first-class tool. The new name is Database Engine Tuning Advisor, and it can be launched from the Windows Start menu.

ISQL is not included in the SQL Server 2005 tool set. Microsoft officially deprecated ISQL in SQL Server 2000 and it is not shipped in SQL Server 2005. As its replacement, you should consider using SQLCMD.

Table 1-1 describes the relationship between functionality of SQL Server 2000 and SQL Server 2005 Tools.