Multithreaded Bulk Copy. A rare tool for rare situations, built only for theorical purposes, that may be useful to transfer a large amount of clustered data from a SQL Server instance to another.

SqlBulkCopy is usual to copy SQL tables from one instance to another. Usually we likely decide to use the Import/Export wizard, an Integration Services package or a method to transfer data as a text file. But problems may arise if we are talking about tables with more than 300 millions of records or 30gb and more and they must be copied in a minimum time.

Additional notes:
Performance gain will be achieved under certain circunstances, and sometimes it will not be percieved due to the nature of the data inside the clustered column. First of all it's necessary to clarify that clustered index saves statistics information only of the first column of a compound index, so it became more critical that the clustered index be well design.

Another issue that may be encounter is the amount of Null data. Statistics talk about non null data, so if the table has an 80% of null data multithreading will not benefit from it, as all null data is copied in one thread as a unique batch.

The license of this software is Free, you can free download and free use this server utility software.