Command Prompt Utility Reference (Database Engine)

 

Applies To: SQL Server 2016

Command prompt utilities enable you to script SQL Server operations. The following table contains a list of command prompt utilities that ship with SQL Server.

UtilityDescriptionInstalled in
bcp UtilityUsed to copy data between an instance of Microsoft SQL Server and a data file in a user-specified format.<drive:>\Program Files\MicrosoftSQL Server\Client SDK\ODBC\110\Tools\Binn
dta UtilityUsed to analyze a workload and recommend physical design structures to optimize server performance for that workload.<drive>:\Program Files\Microsoft SQL Server\130\Tools\Binn
dtexec UtilityUsed to configure and execute an Integration Services package. A user interface version of this command prompt utility is called DTExecUI, which brings up the Execute Package Utility.<drive>:\Program Files\Microsoft SQL Server\130\DTS\Binn
dtutil UtilityUsed to manage SSIS packages.<drive>:\Program Files\Microsoft SQL Server\130\DTS\Binn
Deploy Model Solutions with the Deployment UtilityUsed to deploy Analysis Services projects to instances of Analysis Services.<drive>:\Program Files\Microsoft SQL Server\130\Tools\Binn\VShell\Common7\IDE
osql UtilityAllows you to enter Transact-SQL statements, system procedures, and script files at the command prompt.<drive>:\Program Files\Microsoft SQL Server\130\Tools\Binn
Profiler UtilityUsed to start SQL Server Profiler from a command prompt.<drive>:\Program Files\Microsoft SQL Server\130\Tools\Binn
RS.exe Utility (SSRS)Used to run scripts designed for managing Reporting Services report servers.<drive>:\Program Files\Microsoft SQL Server\130\Tools\Binn
rsconfig Utility (SSRS)Used to configure a report server connection.<drive>:\Program Files\Microsoft SQL Server\130\Tools\Binn
rskeymgmt Utility (SSRS)Used to manage encryption keys on a report server.<drive>:\Program Files\Microsoft SQL Server\130\Tools\Binn
sqlagent90 ApplicationUsed to start SQL Server Agent from a command prompt.<drive>:\Program Files\Microsoft SQL Server\<instance_name>\MSSQL\Binn
sqlcmd UtilityAllows you to enter Transact-SQL statements, system procedures, and script files at the command prompt.<drive:>\Program Files\MicrosoftSQL Server\Client SDK\ODBC\110\Tools\Binn
SQLdiag UtilityUsed to collect diagnostic information for Microsoft Customer Service and Support.<drive>:\Program Files\Microsoft SQL Server\130\Tools\Binn
sqllogship ApplicationUsed 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.<drive>:\Program Files\Microsoft SQL Server\130\Tools\Binn
SqlLocalDB UtilityAn execution mode of SQL Server targeted to program developers.<drive>:\Program Files\Microsoft SQL Server\130\Tools\Binn\
sqlmaint UtilityUsed to execute database maintenance plans created in previous versions of SQL Server.<drive>:\Program Files\Microsoft SQL Server\MSSQL13.MSSQLSERVER\MSSQL\Binn
sqlps UtilityUsed to run PowerShell commands and scripts. Loads and registers the SQL Server PowerShell provider and cmdlets.<drive>:\Program Files\Microsoft SQL Server\130\Tools\Binn
sqlservr ApplicationUsed to start and stop an instance of Database Engine from the command prompt for troubleshooting.<drive>:\Program Files\Microsoft SQL Server\MSSQL13.MSSQLSERVER\MSSQL\Binn
Ssms UtilityUsed to start SQL Server Management Studio from a command prompt.<drive>:\Program Files\Microsoft SQL Server\130\Tools\Binn\VSShell\Common7\IDE
tablediff UtilityUsed to compare the data in two tables for non-convergence, which is useful when troubleshooting a replication topology.<drive>:\Program Files\Microsoft SQL Server\130\COM

To access SQL Server Configuration Manager Using Windows 8

Because SQL Server Configuration Manager is a snap-in for the Microsoft Management Console program and not a stand-alone program, SQL Server Configuration Manager not does not appear as an application when running Windows 8. To open SQL Server Configuration Manager, in the Search charm, under Apps, type SQLServerManager12.msc (for SQL Server 2014) or SQLServerManager11.msc for (SQL Server 2012), and then press Enter.

ConventionUsed for
UPPERCASEStatements and terms used at the operating system level.
monospaceSample commands and program code.
italicUser-supplied parameters.
boldCommands, 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

Community Additions

ADD
Show: