MS Access to PostgreSQL

MS Access to PostgreSQL converter is a program to migrate Microsoft Access databases to on-premises or cloud PostgreSQL.

Features All versions of Microsoft Access are supported All versions of PostgreSQL (starting from v9.0) are supported Microsoft Access is not required Indexes and relationships between tables are migrated Queries are converted into PostgreSQL views Option to export the data into PostgreSQL script file Option to merge MS Access data into an existing PostgreSQL database SSL connection for PostgreSQL is supported  Stores conversion settings into profile Command line support Quick Launch 1-year subscription for updates

Requirements

• Supported OS: Windows 7/8/10/11, Server 2008/2012/2016/2019/2022, Linux with WINE (contact us if you need version for Windows XP or Server 2003)
• Necessary privileges to write into the destination database

Limitations

• Access to PostgreSQL converter does not process system (hidden) tables
• Access to PostgreSQL converter does not convert forms, reports and Visual Basic scripts
• Demo version converts only 50 records per table
• Demo version does not convert queries/views and relationships between tables

PostgreSQL dump file

MS Access to PostgreSQL converter allows users to migrate FoxPro database into PostgreSQL format even when there is no connection to PostgreSQL server available. Following this way, the program converts FoxPro data into a local PostgreSQL dump file instead of migrating it to PostgreSQL server directly. The resulting file contains PostgreSQL statements to create all tables and to fill them with the data. Click here to learn how to import dump file into PostgreSQL database.

Converting queries

MS Access to PostgreSQL converter can process about 90% of syntax constructions used in Microsoft Access queries. Below there is example of conversion results for the query containing 'join'-constructions and few calls of MS Access embedded functions.

Here is how it looked into Microsoft Access:

And this is the resulting view in the destination database:

Quick Launch

Once you stored conversion settings into profile you can run the program in Quick Launch mode. Just launch Windows Explorer and double-click on the profile description (.a2p) file with left mouse button. This will cause MS Access to PostgreSQL converter to run with loading the necessary settings from the specified profile. Then you will be taken right to the screen with progress of conversion without entering all conversion settings.

Try before you buy

Still not sure the program fits your needs? Try free demo version of MS Access to PostgreSQL converter with limited features. It converts 50 records per database table and does not convert queries/views, relationships between tables. Test the quality of the demo and purchase full featured one if satisfied with the results.

Purchasing

Intelligent Converters software is distributed in electronic form trough downloading from the official server. Delivery on CD is also possible and requires extra fee. Select the appropriate software package in the table below and click BUY NOW link. To learn about available payment options visit the Ordering Page.

MS Access to PostgreSQL converter single user license	$59	BUY NOW
PostgreSQL Migration Toolkit	$99	BUY NOW