Some years ago, EarthSoft introduced functionality that used SQL Server's native SqlBulkCopy functionality (e.g., BulkInsert) to push data to the database during the Commit step in EDP. This functionality would only work for certain tables and certain commit modes (e.g., it would fail if any rows already existed in the database). When it succeeded, this functionality was faster than the default approach of sending one row at a time to the database.
We have now implemented our own batch insert functionality that is similar in purpose, but uses table-valued variables. The batch insert is more robust (e.g., it will work with all commit modes). For users committing data to remote databases, performance should improve.
There are some differences in how the old bulk insert committed data versus the new batch insert, including:
- Decimal and date/time values used to be truncated when necessary; now those values are rounded (when necessary).
- Empty strings used to be inserted directly; now empty strings are converted to null values.
- If a null value is inserted into a column with a default value defined, the default value will be used.
The SkipBulkCopy config setting may still be used to skip the batch insert functionality.
Corrected misspelling in mapping details for mapping in SEDD format. The SEDD format now loads appropriately in Professional EDP.
A bug occurred when EDP was saving an EDD as a zip file and the first row of data had been deleted prior to saving. In practice, this would only likely affect a system that is using a recent version of SplitByFacilityFileMonitor. This bug has been resolved such that the EDD zip files save as expected, even if the first row of data has been deleted.
Preserved the case of primary keys in the Collect Inspection format
Icons on the ribbons in EDP were updated to be consistent with changes to EQuIS Professional.
Fixed an issue where empty values in XML EDD files would cause incorrect error flagging.
Default values are now set when loading XML data files in EDP.
Copyright © 2020 EarthSoft, Inc • Modified: 27 Mar 2020