Database Engine Tools

Microsoft SQL Server 2008 includes a complete set of tools and command prompt utilities that allow users, programmers, and administrators to:

* Administer and configure SQL Server.

* Determine the catalog information in a copy of SQL Server.

* Design and test queries for retrieving data.

* Copy, import, export, and transform data.

* Provide diagnostic information.

* Start and stop SQL Server.

Command prompt – CMD – utilities that come with Microsoft SQL Server

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\100\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\100\Tools\Binn
dtexec Utility (SSIS Tool) 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\100\DTS\Binn
dtutil Utility (SSIS Tool) Used to manage SSIS packages. <drive>:\Program Files\Microsoft SQL Server\100\DTS\Binn
Deployment Utility (Analysis Services – Multidimensional Data) Used to deploy Analysis Services projects to instances of Analysis Services. <drive>:\Program Files\Microsoft SQL Server\100\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\100\Tools\Binn
Profiler Utility Used to start SQL Server Profiler from a command prompt. <drive>:\Program Files\Microsoft SQL Server\100\Tools\Binn
rs Utility Used to run scripts designed for managing Reporting Services report servers. <drive>:\Program Files\Microsoft SQL Server\100\Tools\Binn
rsconfig Utility Used to configure a report server connection. <drive>:\Program Files\Microsoft SQL Server\100\Tools\Binn
rskeymgmt Utility Used to manage encryption keys on a report server. <drive>:\Program Files\Microsoft SQL Server\100\Tools\Binn
sqlagent90 Application Used to start SQL Server Agent from a command prompt. x:\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\100\Tools\Binn
SQLdiag Utility Used to collect diagnostic information for Microsoft Customer Service and Support. <drive>:\Program Files\Microsoft SQL Server\100\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\100\Tools\Binn
sqlmaint Utility Used to execute database maintenance plans created in previous versions of SQL Server. x:\Program Files\Microsoft SQL Server\MSSQL10_50.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\100\Tools\Binn
sqlservr Application Used to start and stop an instance of Database Engine from the command prompt for troubleshooting. x:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Binn
Ssms Utility Used to start SQL Server Management Studio from a command prompt. <drive>:\Program Files\Microsoft SQL Server\100\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\100\COM

Any comments will be learning point.

Mehboob

SQL & SPS DBA – MCTS

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: