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.
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.