Bulk Insert and Quantization options.

To speed up migration/ synchronization process for large databases or for rational memory consumption Bulk Insert and Quantization features have been implemented. You can turn them on and off at the customization stage.

Bulk Insert and quantization options

If your data migration process is time-critical, it takes less time to convert data with checked Bulk Insert option. Bulk Insert feature inserts bunch of several records to a target database at a time that speeds up a whole database migration significantly.

With checked Quantization option our converters/ synchronizers handle large tables with Million of rows more efficiently and the memory usage is not rising too high. Programs read a source database, splits the whole record into portions to upload them in course to a destination database.

Try to use quantization option if you met the following memory issues while converting/ sync data.

"Timeout Expired" error.
            “Out of memory for query result” error.
            “Query Result Set too Large” error. 

Note: Pay an attention that Sync tools do not support Bulk Insert. Converters support both Quantization and Bulk Insert options.

Bulk Insert and Quantization options are supported by the following Converter/Sync tools as shown below:

  Destinations
Access FoxPro Excel MS SQL Server MySQL PostgreSQL SQLite Firebird Oracle IBM DB2
Sources
Access :B :B :B :B
FoxPro :Q
:Q
:Q
:Q
  :BQ
:Q
  :BQ
:Q
  :BQ
:Q
Excel :B :B
MS SQL Server :Q
:Q
:Q
:Q
:Q   :BQ
:Q
  :BQ
:Q
  :BQ
:Q
  :BQ
:Q
:Q
:Q
:Q
:Q
  :BQ
:Q
MySQL :Q
:Q
:Q
:Q
:Q   :BQ
:Q
  :BQ
:Q
  :BQ
:Q
  :BQ
:Q
:Q
:Q
:Q
:Q
  :BQ
:Q
PostgreSQL :Q
:Q
  :BQ
:Q
  :BQ
:Q
  :BQ
:Q
SQLite :Q
:Q
:Q
:Q
  :BQ
:Q
  :BQ
:Q
  :BQ
:Q
:Q
:Q
Firebird :B :B
Oracle :B :B :B
IBM DB2   :BQ
:Q
  :BQ
:Q
  :BQ
:Q

Conventional signs are listed below.

  • - Convert
  • - Sync
  • B- Bulk Insert
  • Q- Quantization
comments powered by Disqus