In addition to SQL Server 2008's built-in XML support, there are many development, support, and administration tools designed to take advantage of XML. Many of them come standard with SQL Server, while others are third-party applications. In this chapter, I will give a brief overview of some of the more useful XML-based tools and utilities available.
The Bulk Copy Program, or BCP for short, is SQL Server's command-line tool for bulk loading data from flat files into SQL Server tables. BCP can use XML format files to specify the format, data types, and flat file-to-database column mappings. BCP can generate XML format files automatically from the command line, with the
-x command-line options, ...