title: "SQL Command Prompt Utilities (Database Engine) | Microsoft Docs" ms.custom: "" ms.date: "03/14/2017" ms.prod: "sql-non-specified" ms.prod_service: "sql-tools" ms.service: "" ms.component: "misc" ms.reviewer: "" ms.suite: "sql" ms.technology:
- "database-engine" ms.tgt_pltfrm: "" ms.topic: "article" helpviewer_keywords:
- "command prompt utilities [SQL Server]"
- "command prompt utilities [SQL Server], about command prompt utilities"
- "command prompt [SQL Server]"
- "utilities [SQL Server], command prompt"
- "command prompt [SQL Server], utilities" ms.assetid: 48364bd9-6ea7-45e9-a332-acf3d81bbfae caps.latest.revision: 90 author: "stevestein" ms.author: "sstein" manager: "craigg" ms.workload: "On Demand" monikerRange: ">= aps-pdw-2016 || = azuresqldb-current || = azure-sqldw-latest || >= sql-server-2016 || = sqlallproducts-allversions"
[!INCLUDEappliesto-ss-asdb-asdw-pdw-md] Command prompt utilities enable you to script [!INCLUDEssNoVersion] operations. The following table contains a list of command prompt utilities that ship with [!INCLUDEssNoVersion].
| Utility | Description | Installed in |
|---|---|---|
| bcp Utility | Used to copy data between an instance of [!INCLUDEmsCoName] [!INCLUDEssNoVersion] and a data file in a user-specified format. | <drive:>\Program Files\[!INCLUDEmsCoName][!INCLUDEssNoVersion]\Client SDK\ODBC\110\Tools\Binn |
| dta Utility | Used to analyze a workload and recommend physical design structures to optimize server performance for that workload. | [!INCLUDEssInstallPathVar]Tools\Binn |
| dtexec Utility | Used to configure and execute an [!INCLUDEssISnoversion] package. A user interface version of this command prompt utility is called DTExecUI, which brings up the Execute Package Utility. | [!INCLUDEssInstallPathVar]DTS\Binn |
| dtutil Utility | Used to manage SSIS packages. | [!INCLUDEssInstallPathVar]DTS\Binn |
| Deploy Model Solutions with the Deployment Utility | Used to deploy [!INCLUDEssASnoversion] projects to instances of [!INCLUDEssASnoversion]. | [!INCLUDEssInstallPathVar]Tools\Binn\VShell\Common7\IDE |
| mssql-scripter (Public Preview) | Used to generate CREATE and INSERT T-SQL scripts for database objects in SQL Server, Azure SQL Database, and Azure SQL Data Warehouse. | See our GitHub repo for download and usage information. |
| osql Utility | Allows you to enter [!INCLUDEtsql] statements, system procedures, and script files at the command prompt. | [!INCLUDEssInstallPathVar]Tools\Binn |
| Profiler Utility | Used to start [!INCLUDEssSqlProfiler] from a command prompt. | [!INCLUDEssInstallPathVar]Tools\Binn |
| RS.exe Utility (SSRS) | Used to run scripts designed for managing [!INCLUDEssRSnoversion] report servers. | [!INCLUDEssInstallPathVar]Tools\Binn |
| rsconfig Utility (SSRS) | Used to configure a report server connection. | [!INCLUDEssInstallPathVar]Tools\Binn |
| rskeymgmt Utility (SSRS) | Used to manage encryption keys on a report server. | [!INCLUDEssInstallPathVar]Tools\Binn |
| sqlagent90 Application | Used to start [!INCLUDEssNoVersion] Agent from a command prompt. | <drive>:\Program Files\Microsoft SQL Server\<instance_name>\MSSQL\Binn |
| sqlcmd Utility | Allows you to enter [!INCLUDEtsql] statements, system procedures, and script files at the command prompt. | <drive:>\Program Files\[!INCLUDEmsCoName][!INCLUDEssNoVersion]\Client SDK\ODBC\110\Tools\Binn |
| SQLdiag Utility | Used to collect diagnostic information for [!INCLUDEmsCoName] Customer Service and Support. | [!INCLUDEssInstallPathVar]Tools\Binn |
| sqllogship Application | 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. | [!INCLUDEssInstallPathVar]Tools\Binn |
| SqlLocalDB Utility | An execution mode of [!INCLUDEssNoVersion] targeted to program developers. | [!INCLUDEssInstallPathVar]Tools\Binn| |
| sqlmaint Utility | Used to execute database maintenance plans created in previous versions of [!INCLUDEssNoVersion]. | <drive>:\Program Files\Microsoft SQL Server\MSSQL13.MSSQLSERVER\MSSQL\Binn |
| sqlps Utility | Used to run PowerShell commands and scripts. Loads and registers the [!INCLUDEssNoVersion] PowerShell provider and cmdlets. | [!INCLUDEssInstallPathVar]Tools\Binn |
| sqlservr Application | Used to start and stop an instance of [!INCLUDEssDE] from the command prompt for troubleshooting. | <drive>:\Program Files\Microsoft SQL Server\MSSQL13.MSSQLSERVER\MSSQL\Binn |
| Ssms Utility | Used to start [!INCLUDEssManStudioFull] from a command prompt. | [!INCLUDEssInstallPathVar]Tools\Binn\VSShell\Common7\IDE |
| tablediff Utility | Used to compare the data in two tables for non-convergence, which is useful when troubleshooting a replication topology. | [!INCLUDEssInstallPathVar]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. |
Replication Distribution Agent
Replication Log Reader Agent
Replication Merge Agent
Replication Queue Reader Agent
Replication Snapshot Agent