SQL Server 2008 R2 comes with set of command line tools. They are handy tools which can be used in any scripting, batch program.
Category | Utility |
SSIS | dtexec Utility (SSIS Tool) |
dtutil Utility (SSIS Tool) | |
SSAS | Deployment Utility (Analysis Services - Multidimensional Data) |
SSRS | rs Utility |
rsconfig Utility | |
rskeymgmt Utility | |
Data Tools | tablediff Utility |
bcp Utility | |
TSQL | sqlcmd Utility |
osql Utility (Deprecated) | |
Profiler | Profiler Utility |
Diagnostic | SQLdiag Utility |
Backup | sqllogship Application |
maintenance plan | sqlmaint Utility |
Power Shell | sqlps Utility |
DB Engine | sqlservr Application |
SSMS | Ssms Utility |
DB Tuning | dta Utility |
SQL Agent | sqlagent90 Application |
The blue highlight are frequently used commands.
For details on each command check out MSDN http://msdn.microsoft.com/en-us/library/ms162843.aspx