PostgreSQL to MySQL Converter

admin

8 years ago

PostgreSQL to MySQL Converter is a best program that will convert PostgreSQL Databases to MySQL. PostgreSQL is a powerful, open source object-relational database system. It has more than 15 years of active development and a proven architecture that has earned it a strong reputation for reliability, data integrity, and correctness. MySQL is the world’s most used relational database management system (RDBMS) that runs as a server providing multi-user access to a number of databases. Convert databases from PostgreSQL to MySQL or from MySQL to PostgreSQL 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! PostgreSQL to MySQL is also applicable for MySQL database migration to another MySQL database or to another MySQL server. Moreover, PostgreSQL to MySQL Converter is quite well for copying PostgreSQL database to another MySQL database.

PostgreSQL to MySQL Converter Freeware Features

One page interface;
Transfer data directly from one server to another;
Select tables to transfer;
Transfer password protected databases;
Supports both shared security and user-level security;
Optional transfer of indexes;
Optional transfer of records;
Optional transfer of default values in field definitions;
Identifies and transfers auto number field types;
Easy install, uninstall and upgrade;
No need to set up an ODBC connection, the program will handle that for you;
Automation of the conversion process with task planner scheduler;
High speed data conversion. PostgreSQL2MySQL speed noticeably exceeds average showing in this category as the program works with direct PostgreSQL to MySQL server;
Primary keys and Indexes support ;
Foreign keys (relations) support;
MySQL schemes support.

PostgreSQL to MySQL Converter Features (Pro Ver.)

Select fields to transfer;
Create a dump file;
Saving data into a MySQL Dump and PHP script for export to MySQL database;
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;
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);
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;
`GUID` SQL database type support;
`OLE Object` packages support;
Ability to connect to MySQL database servers located on Unix-like and Windows machines;
Full documentation supplied with the software;
Multilanguage Support (English, French, Russian, German, Spanish, Italian, Greek and Danish).

PostgreSQL to MySQL Converter System Requirements

Windows 8/Windows 7/Vista/XP/2000/NT (NT only with Internet Explorer 4.01)
At least 64 MB of RAM
Necessary privileges to write into database on the target MySQL server .
PostgreSQL 7/8/9
MySQL 4x/5.X

Using PostgreSQL to MySQL Converter

In the first step you are asked to supply the connection settings of the Microsoft SQL Database to convert. If your SQL database requires you to log in you can specify a user name and password.

The destination database and MySQL server connection settings are specified as shown below. You will have the choice of placing the result in a dump file instead of transferring it directly to another MySQL database.

You can specify exactly which tables you want to transfer to the destination database. Just check the box in front of each table name you want to transfer and click next. Select tables to convert (ctrl/shift click).

Check conversion options accordly (create schema, copy data, etc. Additional transfer options can be set in the dialog shown below. Here you can specify if you want to transfer the indexes of the SQL database to MySQL. You can also select not to transfer any records. This will only create the tables in the destination table and leave them empty.

In both SQL and MySQL fields can have default values. When creating the tables in MySQL the program can preserve the default values specified in the SQL field definition. Also auto number properties of a field can be transferred if you check the Auto number properties box.

Press Convert button to start convertion process. The transfer will now run until all the selected tables are transferred. When the transfer is done you will see a small report telling you how much data was transferred.

When conversion is finished, apply constraints and indexes (if any).

The settings of the wizard can be saved in a .ini file.