Command Prompt Utilities Enhancements
Microsoft SQL Server 2005 introduces a number of new command prompt utilities to support new features introduced in this version of SQL Server.
For information about new or enhanced SQL Server user interface tools, such as SQL Server Profiler, SQL Server Management Studio, or the Business Intelligence Development Studio, see Tools Enhancements.
Database Engine Utilities Enhancements
New sqlcmd Utility
The sqlcmd utility replaces the osql and isql utilities. sqlcmd uses the OLE DB API to communicate with an instance of the SQL Server Database Engine, while the earlier utilities used the ODBC or DB-Library APIs. In addition to supporting the functionality available in the earlier utilities, sqlcmd also introduces a richer set of commands that allow it to operate better in application scripts, such as Visual Basic scripts.
For more information, see sqlcmd Utility.
New sqlwb Utility
The sqlwb utility can be used to launch the new SQL Server Management Studio from the command prompt.
For more information, see sqlwb Utility and New SQL Server Management Studio.
New Profiler90 Utility
The Profiler90 utility can be used to launch the SQL Server Profiler tool from the command prompt.
For more information, see profiler90 Utility and SQL Server Profiler Enhancements.
New dta Utility
The dta utility is the command prompt version of Database Engine Tuning Advisor. It can be used to analyze a workload and recommends physical design structures to improve server performance for that workload.
For more information, see dta Utility and New Database Engine Tuning Advisor.
Integration Services Utilities Enhancements
New dtexec Utility
The dtexec command prompt utility is used to configure and execute Integration Services packages. The dtexec utility provides access to all the package configuration and execution features, such as connections, properties, variables, logging, and progress indicators. The dtexec utility provides the ability to load packages from three sources: a Microsoft SQL Server database, the Integration Services service, and the file system.
For more information, see dtexec Utility.
New dtutil Utility
The dtutil command prompt utility is used to manage Integration Services packages stored in three locations: Microsoft SQL Server database, the Integration Services package store, and the file system.
For more information, see dtutil Utility.
Replication Utilities Enhancements
New tablediff Utility
The tablediff utility is used to compare the data in two tables for nonconvergence, and is particularly useful for troubleshooting nonconvergence in a replication topology.
For more information, see tablediff Utility.