After loading the Migration Wizard, click on the Overview page to begin the migration process. You will first connect to the source PostgreSQL database. Here you will provide the information about the PostgreSQL RDBMS that you are migrating from, the ODBC driver that will be used for the migration, and all of the parameters required for the connection. The name of the ODBC driver is the one you set up when you registered your psqlODBC driver with the driver manager.button in the
Opening the Database System dropdown will reveal each RDBMS that is supported on your system. Select PostgreSQL from the list. Below that is the Stored Connection dropdown, which is optional. Stored connections will be listed here, which are connections saved after defining a connection with the Store connection for future use as checkbox enabled.
The three Connection Method options are:
ODBC (manually entered parameters): Each parameter, like a username, is defined separately
ODBC Data Source: For pre-configured data sources (DSN) -- you can optionally create a DSN using the ODBC Administrator
ODBC (direct connection string): A full ODBC connection string
The psqlODBC driver does not allow a connection without specifying a database name.
The migration process is similar to other databases. See Section 10.6.4, “PostgreSQL Type Mapping” for information on how the migration wizard migrates types from PostgreSQL to MySQL, and Section 10.2.1, “A Visual Guide to Performing a Database Migration” for a general migration guide.