DBSync for MySQL & PostgreSQL is a reliable bi-directional database migration tool which allows you to synchronize and convert from:
MySQL to PostgreSQL
MySQL to MySQL
PostgreSQL to MySQL
PostgreSQL to PostgreSQL.
Synchronize and convert databases from MySQL to PostgreSQL or from PostgreSQL to MySQL rapidly and reliably! Operate with a whole database or select only needed tables, fields, indexes and foreign keys to proceed! Reach the desired result by simply configuring of several options through Wizard interface or in command line mode! DBSync for MySQL & PostgreSQL is also applicable for PostgreSQL database synchronization and migration to another PostgreSQL database or even to another PostgreSQL server. Moreover, DBSync for MySQL & PostgreSQL is quite well for MySQL database synchronizing and migration to another MySQL database or to another MySQL server.
Features:
Insert-synchronization and Update-synchronization available;
Database objects (tables, fields, indexes and foreign keys) remapping;
Interactive (GUI) mode / command line mode;
Feature to replace symbols in names of tables and fields (which are required not to be used as they are the symbols reserved for DBMS internal purposes) with a substitute symbol;
Automation of the conversion and synchronization process with Task Scheduler;
Ability to select ISAM, MYISAM, HEAP, InnoDB or BDB table types when copying data to MySQL;
High speed data conversion and synchronization. DBSync for MySQL & PostgreSQL speed noticeably exceeds average showing in this category as the program works with Direct Access to PostgreSQL server and to MySQL server not through ODBC like other Similar converters;
Unicode Support/Connection character sets support:
MULE_INTERNAL, SQL_ASCII, LATIN1, LATIN2, LATIN5, LATIN7, KOI8, ALT, WIN1250, WIN, WIN1256, ISO_8859_7, ISO_8859_8, UNICODE (utf-8) for PostgreSQL server,
LATIN1, LATIN2, LATIN5, LATIN7, ARMSCII8, ASCII, CP1250, CP1251, CP1256, CP1257, CP850.
