Nonvisual Administration Tools and Command-Line Tools
A DBA probably spends the majority of his or her time using the visual administration tools included with SQL Server. However, there are several nonvisual administration tools that a DBA might also use: BCP, ISQL, OSQL, TEXTCOPY, and ODBCPING.
BCP
BCP stands for Bulk Copy Program. It is a command-line utility that enables you to import and export data to and from SQL Server. The advantage of BCP is that it is fast. Users new to SQL Server are often amazed at how quickly it operates. The drawback of BCP is that it can be difficult to use.
By default, BCP.EXE is installed in the C:\Program Files\Microsoft SQL Server\MSSQL\Binn directory of SQL Server. The syntax for BCP is shown in Listing 2.1 ...
Get Microsoft® SQL Server™ 2000 DBA Survival Guide, Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
