Access to PostgreSQL

Due to incompatibility issues, database migration requires specialized software, regardless of the servers we are talking about. Having that in mind, the developers of Access to PostgreSQL created several tools to help database managers export their data without risks and with minimum effort.

Thanks to the wizard-based approach, working with Access to PostgreSQL is a matter of following the on-screen instructions and hitting the “Next” button to go to the next step. You are offered detailed instructions, most requiring you to enter the connection details and the databases to migrate.

Access to PostgreSQL can migrate data directly to PostgreSQL server, but you can also use it to export the data to a script file that can be later used for migrating databases. All editions of Microsoft Access are supported, whereas the application can export to PostgreSQL version 9.0 and higher.

The first step of the wizard requires you to enter the connection details to the PostgreSQL server, including the host name or IP address, the used port number, the username and password. If you want to connect to the non-default database, you must specify its name before proceeding. SSL connection is possible.

Next, you must go through configuring the MS Access user-level security settings, if any, while the third step requires you to select the target databases, both the source and the destination ones. Next, the PostgreSQL schema and the conversion settings must be specified, along with the tables to convert.

Access to PostgreSQL facilitates the conversion of Access databases to PostgreSQL server, allowing you to create a new database or overwrite an existing one. The application can migrate both relationships and indexes in the source database, while queries are converted into views. One of the most important perks of this application is its wizard-based approach, which helps carry out the database migration task much smoother.