We solve complex problems of data modeling and develop tools and solutions to let business perform best through data analysis.

Complex challenges made simple

SQLBI is a consulting firm with a strong and unique experience in Business Intelligence, centered around Microsoft technologies – SQL Server and SQL Server Integration Services (SSIS) and SQL Server Analysis Services (SSAS).


We help companies make sense of the information they have available so that they can take strategic informed decisions that deliver better results and performance. 

SqlBulkTool Project

SqlBulkTool

 

SqlBulkTool is a command line utility that is used to quickly create a mirror of a database. It reads its configuration from an XML file containing source and destination command strings and a list of all the tables to mirror and then handles the work of copying the database in an automated and highly parallelized way.

The parallelism can use the partition capabilities of SQL Server 2005: to handle a huge table it is enough to partition it to make the tool load it by running each single partition in a separate thread, dramatically increasing table load time. In the case where no partitioning is defined the parallelism is handled at the table level.

The project is freeware, full source code is available.

 

Download

2006.07.14 SqlBulkTool 1.0 Source and executables

Articles and History

2006.07.14 SqlBulkTool General description and features