Posted on 2018-08-22 by Spectral Core
Related Proprietary

Full Convert allows easy copying of tables and data between 40 or so supported databases. It will create all the tables, copy all of your data, then create indexes and foreign keys. It has powerful mapping and customization features and uses optimal copying mode for each table separately to achieve the best possible throughput.

Import into PostgreSQL from any of the source databases has been highly optimized, while keeping memory consumption extremely low. Typical conversion from almost any source database into local PostgreSQL target is in low hundreds of thousands of records per second with under 200MB of RAM usage. We support almost all Postgres data types, including spatial types.

Recent updates:

  • Fixed certain edge cases in Paradox BCD data reading
  • Updated support for Java databases (Derby, H2, HSQLDB)
  • Fixed Informix boolean datatype detection
  • Fixed reading of MySQL data types from SQL script files
  • Added missing IKVM dlls
  • Fixed HSQLDB reserved word handling
  • Improved auto-detection of Paradox and Interbase databases
  • Added support for SIARD 2.1
  • Added int datatype to SQLite target instead of forcing bigint for all integral types
  • Added support for Amazon RedShift
  • Fixed handling of certain Access driver expections

For more information, please visit the product page: Full Convert.