1. Welcome Screen
On this screen you need to select the conversion scenario. MySQL to PostgreSQL converter provides two options to convert MySQL database into PostgreSQL data source:
2. Connect to PostgreSQL Server
PostgreSQL to MySQL database migration tool can connect to PostgreSQL server in either local or remote mode. Local mode is used to connect to the server launched on the same machine where the converter is running. Remote mode allows to connect to PostgreSQL server launched on another computer.
By default, the conversion tool uses local connection mode. It is indicated by radio button "Local" selected. To establish remote connection, select "Remote" radio button. This option also requires specifying host and port to connect through. Host could be either network name or IP address of the PostgreSQL server. The port value is necessary only if it differs from the default PostgreSQL port number 5432. Otherwise, leave this field as is.
Then user name and password for valid PostgreSQL account must be specified.
3. Connect to MySQL Server
PostgreSQL to MySQL converter can connect to MySQL server via either local or remote mode. Local mode is designed to connect MySQL server launched on the same machine where PostgreSQL to MySQL tool is running. Remote mode allows to connect to MySQL server launched on another computer.
By default, the program uses local connection mode. It is indicated by radio button "Local" selected. To establish remote connection you should select "Remote" radio button. For remote MySQL servers you should also enter host and TCP/IP port to connect through. Host could be either network name or IP address. TCP/IP port value is necessary only if it differs from the default MySQL port number 3306. Otherwise you may leave this field as is.
Finally, you are entering user name and password. You can leave these fields empty for anonymous connection.
4. Select Databases
On this wizard screen PostgreSQL and MySQL databases must be specified. If destination database already exists, the program gives multiple options how to process it:
PostgreSQL to MySQL database migration tool implements synchronization as insert of records missing in the target table and update of existing MySQL records with PostgreSQL data. Source and destination tables must have identical structures and define primary key or unique index for synchronization purpose.
|Also, you can specify log file to write execution traces of the conversion process. Leave this field blank to disable logging.|
Customize Conversion Settings
On this wizard screen you can specify PostgreSQL schema (drop down the combo box to select from list or enter it manually) and customize the conversion process using the following settings:
Note: leave schema name blank to convert tables from all schemas.
5. Select Tables
On this wizard screen you can manage the list of PostgreSQL tables for conversion. In the left part of PostgreSQL to MySQL tool's window there is "Available tables" list box. It contains all available tables of the source database except those that have been selected already. On the right side there is "Selected tables" list box.
To add new PostgreSQL table for converting into MySQL format you select the appropriate item in "Available tables" list box and click "Add" button (or double-click the selected item). Also you can use "Add all" button to insert all available PostgreSQL tables.
To remove an item from "Selected tables" list you should select it and click "Remove" button. You can use "Remove all" button to remove all items from "Selected tables" list box.