command-prompt-utility-reference-database-engine.md

title	Command Prompt Utility Reference (Database Engine) | Microsoft Docs
ms.custom
ms.date	03/14/2017
ms.prod	sql-server-2016
ms.reviewer
ms.suite
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	JennieHubbard
ms.author	jhubbard
manager	jhubbard

Command Prompt Utility Reference (Database Engine)

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
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

To access [!INCLUDEssNoVersion] Configuration Manager Using [!INCLUDEwin8]

Because [!INCLUDEssNoVersion] Configuration Manager is a snap-in for the [!INCLUDEmsCoName] Management Console program and not a stand-alone program, [!INCLUDEssNoVersion] Configuration Manager not does not appear as an application when running [!INCLUDEwin8]. To open [!INCLUDEssNoVersion] Configuration Manager, in the Search charm, under Apps, type SQLServerManager12.msc (for [!INCLUDEssSQL14]) or SQLServerManager11.msc for ([!INCLUDEssSQL11]), and then press Enter.

Command Prompt Utilities Syntax Conventions

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.

See Also

Replication Distribution Agent
Replication Log Reader Agent
Replication Merge Agent
Replication Queue Reader Agent
Replication Snapshot Agent