Export (0) Print
Expand All

Command Prompt Utilities Enhancements

SQL Server 2005

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.

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.

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.

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.

Community Additions

ADD
Show:
© 2014 Microsoft