Access2PostgreSQL PRO 1.6.0
Access2PostgreSQL PRO general info
Access2PostgreSQL Pro with scheduler converts MS Access (mdb) to PostgreSQL and PostgreSQL to Access. You can save data to PHP script or dump (text) file that allows you to get over the restrictions on access to PostgreSQL database.
Windows NT/2000/XP Platform :
7.6 MbFile Size :
Free to try; $55 to buy License :
March 06, 2007 Date Added :
, ms access
, postgresql to access
, postgresql 2access
, database converter
, access2 postgresql pro
, access to postgresql
, command line mode
, data convertibility
Access2PostgreSQL PRO Full Description
Access2PostgreSQL Pro is a database migration tool for data conversion from MS Access database (.mdb file) to PostgreSQL server and PostrgreSQL db to Microsoft Access.
You can convert Access to PostgreSQL or visa versa PostgreSQL to Access simply by configuring several options through Wizard interface or in command line mode. Ability to organize application work using command line parameters is supplemented with a built-in scheduler so you can run the program without user input after scheduling.
Along with general functionality - data importing / exporting - this easy to use converter allows you to store your data to PHP Script.
If a direct access to your PostgreSQL base is denied (no sufficient privileges) you can save your data into a dump file to overcome such restrictions. The primary function of the PostgreSQL privilege system is to authenticate a user connecting from a given host, and to associate that user with privileges on to select, insert, update, and delete a database. The SELECT, INSERT, UPDATE, and DELETE privileges allow you to perform operations on rows in existing tables in a database. The privilege system ensures that all users may perform only the operations allowed to them. Thus in case you have no privileges to create or modify a database on the target PostgreSQL server there is an opportunity to save your data into a dump file. Access2PostgreSQL Pro converter fixes the contents of the source database into a local dump file instead of sending it to PostgreSQL server directly. The destination file will consist of PostgreSQL statements to create all tables and to fill them with the data. Using this dump file PostgreSQL server administrator will add data to your PostgreSQL database.
Unicode Support/Connection character sets support:
LATIN1, LATIN2, LATIN5, LATIN7, ARMSCII8, ASCII, CP1250, CP1251, CP1256, CP1257, CP850, CP852, CP866, DEC8, GEOSTD8, GREEK, HEBREW, HP8, KEYBCS2, KOI8R, KOI8U, MACCE, MACROMAN, SWE7, UTF8 (unicode charset)
Primary keys and Indexes support
Interactive (GUI) mode / command line mode;
Saving data into a dump file, PHP script for export to PostgreSQL database;
Support for MS Access Work Groups;
Support for AutoIncrement (AutoNumber) fields conversion;
Feature to replace symbols in names of tables and fields with a substitute symbol.
Support for field default values conversion;
Automation of the conversion process with built-in scheduler
High speed of data conversion. Access2PostgreSQL Pro speed noticeably exceeds average showing in this category.
Advanced customization options:
- partial selection for database objects to be converted.
- database objects (tables, fields, indexes) renaming before conversion.
- detection of possible conversion errors at customization stage.
Sessions support - all your settings can be saved and restored then.
Data array support
'GUID' Access database type support.
'OLE Object' packages support.
Software related to Access2PostgreSQL PRO
Access2PostgreSQL PRO Rating: