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