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
No comments:
Post a Comment