Access to PostgreSQL Converter is a best program that will convert Microsoft Access Databases to PostgreSQL. Convert databases from MS Access to PostgreSQL or from PostgreSQL to MS Access rapidly and reliably! Operate with a whole database or select only needed tables, fields, indexes and foreign keys to proceed! Reach the desired result by simply configuring of several options through Wizard interface or in command line mode! Access to PostgreSQL is also applicable for PostgreSQL database migration to another PostgreSQL database or to another PostgreSQL server. Moreover, Access to PostgreSQL Converter is quite well for copying MS Access database to another MS Access database.
One page interface;
Transfer data directly from one server to another;
Select tables to transfer;
Transfer password protected databases;
Supports both shared security and user-level security;
Optional transfer of indexes;
Optional transfer of records;
Optional transfer of default values in field definitions;
Identifies and transfers auto number field types;
Easy install, uninstall and upgrade;
Support for MS Access Work Groups;
No need to set up an ODBC connection, the program will handle that for you;
Automation of the conversion process with task planner scheduler;
High speed data conversion. Access2PostgreSQL speed noticeably exceeds average showing in this category as the program works with direct access to PostgreSQL server;
Primary keys and Indexes support ;
Foreign keys (relations) support;
PostgreSQL schemes support.
Select fields to transfer;
Create a dump file;
Saving data into a PostgreSQL Dump and PHP script for export to PostgreSQL database;
Interactive (GUI) mode / command line mode;
Feature to replace symbols in names of tables and fields (which are required not to be used as they are the symbols reserved for DBMS internal purposes) with a substitute symbol;
Unicode Support/Connection character sets support:
MULE_INTERNAL, SQL_ASCII, LATIN1, LATIN2, LATIN5, LATIN7, KOI8, ALT, WIN1250, WIN, WIN1256, ISO_8859_7, ISO_8859_8, UNICODE (utf-8);
Advanced customization options:
- partial selection for database objects to be converted;
- database objects (tables, fields, indexes, foreign keys) tuning up before conversion;
- detection of possible conversion errors on customization stage.
Sessions support – all your settings can be saved and restored later;
Data array support;
`GUID` Access database type support;
`OLE Object` packages support;
Ability to connect to PostgreSQL database servers located on Unix-like and Windows machines;
Full documentation supplied with the software;
Multilanguage Support (English, French, Russian, German, Spanish, Italian, Greek and Danish).
Windows 8/Windows 7/Vista/XP/2000/NT (NT only with Internet Explorer 4.01)
At least 64 MB of RAM
Necessary privileges to write into database on the target PostgreSQL server .
In the first step you are asked to supply the file name of the Microsoft Access Database to convert. If your Access database requires you to log in you can specify a user name, password and a system database.
The destination database and PostgreSQL server connection settings are specified as shown below. You will have the choice of placing the result in a dump file instead of transferring it directly to another PostgreSQL database.
You can specify exactly which tables you want to transfer to the destination database. Just check the box in front of each table name you want to transfer and click next. Select tables to convert (ctrl/shift click).
Check conversion options accordly (create schema, copy data, etc. Additional transfer options can be set in the dialog shown below. Here you can specify if you want to transfer the indexes of the Access database to PostgreSQL. You can also select not to transfer any records. This will only create the tables in the destination table and leave them empty.
In both Access and PostgreSQL fields can have default values. When creating the tables in PostgreSQL the program can preserve the default values specified in the Access field definition. Also auto number properties of a field can be transferred if you check the Auto number properties box.
Press Convert button to start convertion process. The transfer will now run until all the selected tables are transferred. When the transfer is done you will see a small report telling you how much data was transferred.
When conversion is finished, apply constraints and indexes (if any).
The settings of the wizard can be saved in a .ini file.
1.0.1 (2012-02-29) Access to PostgreSQL Converter first release.
Should there be any queries, please don’t hesitate to contact me by firstname.lastname@example.org.