MS Access to PostgreSQL
Latest version 2.1 released 03/11/2020
Access-to-PostgreSQL is a program to migrate Microsoft Access databases to PostgreSQL or Heroku server. Depending on privileges on the target PostgreSQL server, you can export MS Access data into new database or overwrite an existing PostgreSQL database.
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.
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.
And this is the resulting view in the destination database:
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 Access-to-PostgreSQL wizard to launch conversion 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.
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.
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.
|Access-to-PostgreSQL (single user license)
Click here for more information about licensing
|PostgreSQL Migration Toolkit
software pack to convert any data source to PostgreSQL and vice versa