<< Click to Display Table of Contents >> Navigation:  Administration and Configuration > ST_CONFIG Entries > EarthSoft.Common > EarthSoft.Common.Data.Connection.SkipBulkCopy

As described in the EDP Commit techniques article, SqlBulkCopy is one of the techniques that may be used when committing records to the database. In many cases, SqlBulkCopy can decrease the amount of time it takes to insert the data into the database. However, bulk loading rows is a single operation and can cause timeout errors when committing very large datasets (e.g., data migrations). In some situations, it may be desirable to disable SqlBulkCopy and use an EQuIS-specific BatchInsert process that sends data to the database in batches.

 

EQuIS Version: v7+

 

Products Affected: Enterprise EDP, Professional EDP, Professional

 

Requires Module: EDP

 

 

Remarks:

 

By default, SqlBulkCopy is used for all tables. This setting may be used to either (a) disable SqlBulkCopy for all tables or (b) disable SqlBulkCopy for only specific tables. This setting is independent of any particular EDD format; when configured, it will be applied to all formats (as well as loading data manually in Professional).

 

 

Example: The following ST_CONFIG record will skip bulk copy/insert for all tables.

 

 

 

Example: The following ST_CONFIG record will skip bulk copy/insert for just DT_TEST and DT_RESULT (notice the pipe at the beginning and end of STRING_VALUE).