MS Access to PostgreSQL

[Download]  [Buy]
Latest version 1.3 released 06/11/2018

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.

Features
  • All versions of Microsoft Access are supported
  • All versions of PostgreSQL running on Linux/Unix/Windows are supported
  • Indexes and relationships between tables are supported
  • 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
  • Stores conversion settings into profile
  • Command line support
  • Quick Launch
  • Easy-to-use wizard-style interface
  • Full install/uninstall support
  • The product can be customized according to customer requirements
  • Unlimited 24/7 support service
  • 1-year subscription for updates

Requirements

  • Supported OS: Windows XP(SP2 or SP3)/Vista/7/8/10, Server 2003/2008/2012/2016, Linux with WINE
  • Necessary privileges to write into the destination database

Limitations

  • 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 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.

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.

Download trial version of Access-to-PostgreSQL

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.

 

Access-to-PostgreSQL (single user license)
Click here for more information about licensing
$49 BUY NOW
PostgreSQL Migration Toolkit
software pack to convert any data source to PostgreSQL
and vice versa
$99 BUY NOW