DBConvert for MS Access & PostgreSQL Choose Destination

Select a destination database type to be converted (MDB or PostgreSQL).

If you select Access Database you will be invited to specify a Microsoft Access database file (*.mdb), and Username and Password if needed.

Using WorkGroups

When using MS Access WorkGroups select the "Using WorkGroups" check box, and input a proper Username and Password in the corresponding fields appeared.

If you select PostgreSQL as a destination database, specify Hostname, Port, Username, Password and use SSH forwarding if needed.

DBConvert for MS Access & PostgreSQL supports Unicode. To make language special symbols displayed correctly select utf8 in the list box "Connection character set". You can also choose any other character set from the list box. After defining necessary information, click "Test connection" button. This will check if it's possible to connect to your PostgreSQL server with the parameters you specified before.

In case the connection is set successfully the following message appears and you can continue configuring necessary data:

By pressing "Refresh" button you can view all existing databases available on this server for this user and list them in "Database" combo-box.
Choose a PostgreSQL database you'd like to convert. You can also type the name of the database to be converted in this combo it will allow you to save time needed for refreshing information about the bases available.

If you select PostgreSQL Dump as a destination database, you need to do the following:

In "Output file" field enter a name for PostgreSQL Dump (.sql file) to be created. You can also browse it by clicking the button nearby.

In "Database" field enter a name for a database that will be created by the .sql file you specified above. This .sql file will insert data from the Source database to the database with the name you define in "Database" field.

At this step you can set a way the resulting dump file should be formed in. The following settings are available:

Line breaks - this parameter specifies how to separate text lines in the dump file. If your target PostgreSQL server is running on MS Windows platform, you should select 'MS Windows style' option. Otherwise select 'Unix style'.

Insert comments - select this option to add brief comments. It makes the resulting dump file more understandable.

If you select PHP Script as a destination database, specify a destination Hostname, Port, Userame and Password if needed.

In "Output file" field enter a name for PHP Script to be created. You can also browse it by clicking the button nearby.

In "Database" field enter a name for a database that will be created by the PHP Script you specified above. This script will add data from the Source database to the database with the name you define in "Database" field.

At this step you can set a way the resulting dump file should be formed in. The following settings are available:

Click "Next >" to continue.