DBConvert for MySQL & PostgreSQL

DBConvert for MySQL & PostgreSQL allows you to convert from:

• MySQL to PostgreSQL
• MySQL to PostgreSQL Dump
• MySQL to PostgreSQL PHP Script
• MySQL to MySQL
• MySQL to MySQL Dump
• MySQL to MySQL PHP Script
• PostgreSQL to MySQL
• PostgreSQL to MySQL Dump
• PostgreSQL to MySQL PHP Script
• PostgreSQL to PostgreSQL
• PostgreSQL to PostgreSQL Dump
• PostgreSQL to PostgreSQL PHP Script

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! DBConvert for MySQL & PostgreSQL is also applicable for PostgreSQL database migration to another PostgreSQL database or to another PostgreSQL server. Moreover, DBConvert for MySQL & PostgreSQL is quite well for MySQL database migration to another MySQL database or to another MySQL server.

As you know the conversion speed depends on different things: the source file size, the computer performance, the output settings and so on. Now you don't need to search any tips to speed up the conversion. To increase conversion speed we improved our engine for large databases, with approximately 500 thousand records and more. Now they can be converted in 3-5 min for MySQL and in 5-7 min for PostgreSQL.

Features
• Interactive (GUI) mode / command line mode;
• Saving data into a MySQL Dump or PostgreSQL Dump and PHP script for export to PostgreSQL or MySQL database;
• 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 process with task scheduler;
• Ability to select ISAM, MYISAM, HEAP, InnoDB or BDB table types when copying data to MySQL or MySQL Dump
• High speed data conversion. DBConvert for MySQL & PostgreSQL speed noticeably exceeds average showing in this category as the program works with direct access to PostgreSQL server and 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, CP852, CP866, DEC8, GEOSTD8, GREEK, HEBREW, HP8, KEYBCS2, KOI8R, KOI8U, MACCE, MACROMAN, SWE7, TIS620, UTF8 (unicode charset) for MySQL server;
• Primary keys and Indexes support ;
• Foreign keys (relations) support;
• PostgreSQL schemes support;
• Advanced customization options:
- partial selection for database objects to be converted;
- database objects (tables, fields, indexes, foreign keys) tuning up before conversion;
- detection of possible conversion errors on customization stage.
• Sessions support - all your settings can be saved and restored later;
• Data array support;
• `ENUM` and `SET` MySQL database types support;
• `BLOB` conversion support;
• Ability to connect to MySQL and PostgreSQL database servers located on all Unix-like and Windows machines.
• Skins support;
• Multilanguage Support (English/French/Russian);
• 1-year free upgrades.

Requirements| Data Migration MySQL to / from PostgreSQL

• Necessary privileges to write into db on the target PostgreSQL server and MySQL server (optional).
• PostgreSQL 9.x/7.4
• MySQL 4.x/5.x
• Microsoft Visual C++ 2008 x86 Redistributable package