SQL Command Prompt Utilities (Database Engine)
Applies to: SQL Server Azure SQL Database Azure SQL Managed Instance Azure Synapse Analytics Analytics Platform System (PDW)
Command prompt utilities enable you to script SQL Server operations. The following table contains a list of many command prompt utilities that ship with SQL Server.
For information on the main SQL gui and command-line tools, see SQL Tools Overview.
Utility | Description | Installed in |
---|---|---|
bcp Utility | Used to copy data between an instance of Microsoft SQL Server and a data file in a user-specified format. | <drive:>\Program Files\Microsoft SQL Server\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. | <drive>:\Program Files\Microsoft SQL Server\nnn\Tools\Binn |
dtexec Utility | Used 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\nnn\DTS\Binn |
dtutil Utility | Used to manage SSIS packages. | <drive>:\Program Files\Microsoft SQL Server\nnn\DTS\Binn |
Deploy Model Solutions with the Deployment Utility | Used to deploy Analysis Services projects to instances of Analysis Services. | <drive>:\Program Files\Microsoft SQL Server\nnn\Tools\Binn\VShell\Common7\IDE |
osql Utility | Allows you to enter Transact-SQL statements, system procedures, and script files at the command prompt. | <drive>:\Program Files\Microsoft SQL Server\nnn\Tools\Binn |
Profiler Utility | Used to start SQL Server Profiler from a command prompt. | <drive>:\Program Files\Microsoft SQL Server\nnn\Tools\Binn |
RS.exe Utility (SSRS) | Used to run scripts designed for managing Reporting Services report servers. | <drive>:\Program Files\Microsoft SQL Server\nnn\Tools\Binn |
rsconfig Utility (SSRS) | Used to configure a report server connection. | <drive>:\Program Files\Microsoft SQL Server\nnn\Tools\Binn |
rskeymgmt Utility (SSRS) | Used to manage encryption keys on a report server. | <drive>:\Program Files\Microsoft SQL Server\nnn\Tools\Binn |
sqlagent90 Application | Used to start SQL Server Agent from a command prompt. | <drive>:\Program Files\Microsoft SQL Server\<instance_name>\MSSQL\Binn |
sqlcmd Utility | Allows you to enter Transact-SQL statements, system procedures, and script files at the command prompt. | <drive:>\Program Files\Microsoft SQL Server\Client SDK\ODBC\110\Tools\Binn |
SQLdiag Utility | Used to collect diagnostic information for Microsoft Customer Service and Support. | <drive>:\Program Files\Microsoft SQL Server\nnn\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. | <drive>:\Program Files\Microsoft SQL Server\nnn\Tools\Binn |
SqlLocalDB Utility | An execution mode of SQL Server targeted to program developers. | <drive>:\Program Files\Microsoft SQL Server\nnn\Tools\Binn |
sqlmaint Utility | Used to execute database maintenance plans created in previous versions of SQL Server. | <drive>:\Program Files\Microsoft SQL Server\MSSQL13.MSSQLSERVER\MSSQL\Binn |
sqlps Utility | Used to run PowerShell commands and scripts. Loads and registers the SQL Server PowerShell provider and cmdlets. | <drive>:\Program Files\Microsoft SQL Server\nnn\Tools\Binn |
sqlservr Application | Used 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 Utility | Used to start SQL Server Management Studio from a command prompt. | <drive>:\Program Files\Microsoft SQL Server\nnn\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. | <drive>:\Program Files\Microsoft SQL Server\nnn\COM |
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
Phản hồi
https://aka.ms/ContentUserFeedback.
Sắp ra mắt: Trong năm 2024, chúng tôi sẽ dần gỡ bỏ Sự cố với GitHub dưới dạng cơ chế phản hồi cho nội dung và thay thế bằng hệ thống phản hồi mới. Để biết thêm thông tin, hãy xem:Gửi và xem ý kiến phản hồi dành cho