Laserfiche's Microsoft SQL Server Bulk Copy Process (BCP) connector can be used to perform Bulk Copy operations on a SQL Server database.
Bulk copy operations are efficient import and export operations that load data into or export data from a single SQL Server table. Use this connector to quickly import or export a large quantity of data into or out of a SQL Server database. The Microsoft SQL Server BCP connector performs imports and exports faster than the Database connector because it is optimized to reduce overhead. The connector can bypass data integrity checks when loading data and can import and export thousands of documents that can contain thousands of records. Thus, the connector can handle millions of records. Only one bulk copy process runs at a time within the during the same a process.