BulkCopy is a tool used to copy huge amount of data from tables and views. The Bulk Copy Program (BCP) is a command-line utility that ships with SQL Server 2000. With BCP, you can import and export large amounts of data in and out of SQL Server databases. BCP does not copy the structures same as source to destination.
The BCP utility is accessed from the command prompt. The syntax is as follows:
bcp {dbtable | query} {in | out | queryout | format} datafile
[-n native type] [-c character type]
[-S server name] [-U username]
[-P password] [-T trusted connection]