Microsoft® SQL Server 2008 R2 Unleashed

Chapter 5. SQL Server Command-Line Utilities

IN THIS CHAPTER

• What’s New in SQL Server Command-Line Utilities

• The sqlcmd Command-Line Utility

• The dta Command-Line Utility

• The tablediff Command-Line Utility

• The bcp Command-Line Utility

• The sqldiag Command-Line Utility

• The sqlservr Command-Line Utility

This chapter explores various command-line utilities that ship with SQL Server. These utilities give administrators a different way to access the database engine and its related components. In some cases, they provide functionality that is also available with SQL Server’s graphical user interface (GUI). Other command-line utilities provide functionality that is available only from the command prompt. For each utility, this chapter ...