The SQL Server includes a Bulk Copy Program (BCP) which can be used to copy data between servers or databases at high speed. As its name implies, this program is designed to copy bulk amounts of data quickly. The ShowCase Data Distributor now includes a Bulk Insert function within the transfer function. This Bulk Insert uses the Bulk Copy APIs to provide better performance.
At the same time, this Bulk Insert function has the same restrictions. All columns must be copied (the select statement must return a result set matching the destination table). In addition, the "select into/bulkcopy" dboption must be set to true, and indexes should be dropped from the receiving table.
Customer reports have shown the bulk insert function to increase transfer rates by a factor of two to three routinely, depending on data types, hardware configuration, and system loads.