By popular demand, Bulk Insert and Quantization options have been added on the customization stage to speed up conversion / synchronization for large databases. Now DBConvert with the Quantization option can handle operating large tables with millions of rows not rising memory level. This is achieved by splitting the whole record set into portions.

If your data processing is time-critical, the Bulk Insert option is just what you need. It is faster than quantization in times but this method uses the same memory size as conversion with default configuration whereas the quantization option is suitable for rational memory usage but can take more time than usual conversion.

Please read about scenarios in our FAQ section.

This comparison table shows what DBConvert products support these options.

Let's take, for example, DBConvert for MS SQL & MySQL and we'll see "C:bq" on the point of intersection. It means that the conversion process enables both Bulk Insert and Quantization options. If we take DBSync for MS SQL & MySQL, we can see it enables Quantization.

Note: Pay attention that all DBSync tools support only Quantization option. Also it should be noted that the following DBMSs don't have Bulk Insert and Quantization functions at all: Access, Excel, Firebird, Oracle, SQLite, and FoxPro. That's why some of our tools such as DBConvert for MS Access & Firebird, DBConvert for Oracle & MS Access, DBConvert for MS Access & MS FoxPro, etc. support neither Bulk Insert nor Quantization.

Below there are conventional signs.

Source\Destination	Access	FoxPro	Excel	SQL	MySQL	Postgre	SQLite	Firebird	Oracle
Access				C:b	C:b	C:b
FoxPro				C:b	C:b
Excel				C:b	C:b
SQL	C:q S:q	C:q S:q	C:q S:q	C:bq S:q	C:bq S:q	C:bq S:q	C:q S:q	C:q S:q	C:q S:q
MySQL	C:q S:q	C:q S:q	C:q S:q	C:bq S:q	C:bq S:q	C:bq S:q	C:q S:q	C:q S:q	C:q S:q
Postgre	C:q S:q	C:q S:q	C:q S:q	C:bq S:q	C:bq S:q	C:bq S:q	C:q S:q	C:q S:q	C:q S:q
SQLite				C:b	C:b
Firebird				C:b	C:b
Oracle				C:b	C:b

• Bulk - b
• Quantization - q
• Sync - S
• Convert - C