EarthSoft.Common.Data.Connection.SkipBulkCopy

<< Click to Display Table of Contents >>

EQuIS 7  >>  Configuration > ST_CONFIG Entries > EarthSoft.Common >

EarthSoft.Common.Data.Connection.SkipBulkCopy

When committing data to a Microsoft SQL Server database, EDP will use Microsoft's SqlBulkCopy class to bulk load rows directly into the table (instead of inserting the rows one at a time). 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 revert to row-by-row inserts (each individual row insert is a single operation and will reduce the likelihood of a timeout error).

 

EQuIS Version: 7

 

Products Affected: Enterprise EDP, Professional EDP, Professional

 

Requires Module: EDP

 

ST_CONFIG

VALUE

REMARK

VALID VALUES

CONFIG_SECTION

EarthSoft.Common.Data.Connection

Required


CONFIG_KEY

SkipBulkCopy

Required


OBJECT_TYPE

null

not applicable


OBJECT_VALUE

null

not applicable


STRING_VALUE

'*' or pipe-delimited list of table names

Required

Asterisk will skip bulk insert for all tables; pipe-delimited list of tables names (with beginning and ending pipe) will skip bulk insert for just the given table names

 

Remarks:

 

As noted, this setting applies only to Microsoft SQL Server Databases. 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.

 

config_section

config_key

string_value

EarthSoft.Common.Data.Connection

SkipBulkCopy

*

 

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):

 

config_section

config_key

string_value

EarthSoft.Common.Data.Connection

SkipBulkCopy

|DT_TEST|DT_RESULT|