| title | description | author | ms.author | ms.reviewer | ms.date | ms.service | ms.subservice | ms.topic | ms.collection | helpviewer_keywords | monikerRange | |||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SQL Command-Line Utilities (Database Engine) |
Command prompt utilities enable you to script SQL Server operations. This article lists many command-line utilities that ship with SQL Server. |
rwestMSFT |
randolphwest |
maghan |
04/07/2025 |
sql |
tools-other |
conceptual |
|
|
>=aps-pdw-2016 || =azuresqldb-current || =azure-sqldw-latest || >=sql-server-2016 || >=sql-server-linux-2017 |
[!INCLUDE SQL Server Azure SQL Database Synapse Analytics PDW]
Command-line utilities enable you to script [!INCLUDE ssdenoversion-md] operations. The following table contains a list of several command-line utilities that ship with [!INCLUDE ssNoVersion].
For information on the main SQL graphical and command-line tools, see SQL tools overview.
| Utility | Description | Installed in |
|---|---|---|
| bcp | Used to copy data between an instance of [!INCLUDE msCoName] [!INCLUDE ssNoVersion] and a data file in a user-specified format. | <drive:>\Program Files\[!INCLUDE msCoName] [!INCLUDE ssNoVersion]\Client SDK\ODBC\110\Tools\Binn |
| dta | Used to analyze a workload and recommend physical design structures to optimize server performance for that workload. | [!INCLUDE ssinstallpath-md]Tools\Binn |
| dtexec | Used to configure and execute an [!INCLUDE ssISnoversion] package. A user interface version of this command-line utility is called DTExecUI, which brings up the Execute Package Utility. | [!INCLUDE ssinstallpath-md]DTS\Binn |
| dtutil | Used to manage SQL Server Integration Services (SSIS) packages. | [!INCLUDE ssinstallpath-md]DTS\Binn |
| Deploy Model Solutions with the Deployment | Used to deploy [!INCLUDE ssASnoversion] projects to instances of [!INCLUDE ssASnoversion]. | [!INCLUDE ssinstallpath-md]Tools\Binn\VShell\Common7\IDE |
| osql | Allows you to enter [!INCLUDE tsql] statements, system procedures, and script files at the command prompt. | [!INCLUDE ssinstallpath-md]Tools\Binn |
| Profiler | Used to start [!INCLUDE ssSqlProfiler] from a command prompt. | [!INCLUDE ssinstallpath-md]Tools\Binn |
| RS.exe (SSRS) | Used to run scripts designed for managing [!INCLUDE ssRSnoversion] report servers. | [!INCLUDE ssinstallpath-md]Tools\Binn |
| rsconfig (SSRS) | Used to configure a report server connection. | [!INCLUDE ssinstallpath-md]Tools\Binn |
| rskeymgmt (SSRS) | Used to manage encryption keys on a report server. | [!INCLUDE ssinstallpath-md]Tools\Binn |
| sqlagent90 application | Used to start [!INCLUDE ssNoVersion] Agent from a command prompt. | <drive>:\Program Files\Microsoft SQL Server\<instance_name>\MSSQL\Binn |
| sqlcmd | Allows you to enter [!INCLUDE tsql] statements, system procedures, and script files at the command prompt. | <drive:>\Program Files\[!INCLUDE msCoName] [!INCLUDE ssNoVersion]\Client SDK\ODBC\110\Tools\Binn |
| SQLdiag | Used to collect diagnostic information for [!INCLUDE msCoName] Customer Service and Support. | [!INCLUDE ssinstallpath-md]Tools\Binn |
| sqllogship | Used by applications to perform backup, copy, and restore operations and associated clean-up tasks for a log shipping configuration without running the backup, copy, and restore jobs. | [!INCLUDE ssinstallpath-md]Tools\Binn |
| SqlLocalDB | An execution mode of [!INCLUDE ssNoVersion] targeted to program developers. | [!INCLUDE ssinstallpath-md]Tools\Binn |
| sqlmaint | Used to execute database maintenance plans created in previous versions of [!INCLUDE ssNoVersion]. | [!INCLUDE ssinstallpath-md]\MSSQL\Binn |
| sqlps | Used to run PowerShell commands and scripts. Loads and registers the [!INCLUDE ssNoVersion] PowerShell provider and cmdlets. | [!INCLUDE ssinstallpath-md]Tools\Binn |
| sqlservr | Used to start and stop an instance of [!INCLUDE ssDE] from the command prompt for troubleshooting. | <drive>:\Program Files\Microsoft SQL Server\MSSQL16.MSSQLSERVER\MSSQL\Binn |
| ssms | Used to start [!INCLUDE ssManStudioFull] from a command prompt. | [!INCLUDE ssinstallpath-md]Tools\Binn\VSShell\Common7\IDE |
| tablediff | Used to compare the data in two tables for nonconvergence, which is useful when troubleshooting a replication topology. | [!INCLUDE ssinstallpath-md]COM |
| Convention | Used for |
|---|---|
| UPPERCASE | Statements and terms used at the operating system level. |
monospace |
Sample commands and program code. |
| italic | User-supplied parameters. |
| bold | Commands, parameters, and other syntax that must be typed exactly as shown. |