This is the Access2PostgreSQL Pro manual. You will find here anything you need to know about this tool.
Access2PostgreSQL Pro is an effective application which allows to easily convert .mdb (Microsoft Access) databases to PostgreSQL and vice versa, unlike other similar tools, which commonly perform only one-way conversion. Access2PostgreSQL Pro performs Unicode support as well as a large number of useful features. The program is extremely easy to use, it is implemented like a common wizard-like application, so even an inexperienced user will be able to work with it. We doubt that you will have any problems with it, but in any case FAQ page is available for your convenience. Regularly benchmark tests show that Access2PostgreSQL products obviously stand out from the crowd of similar data c onversion tools with its improved general functionality, high speed of conversion and stability of the software.
Features:
- 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
- Foreigns keys
- 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.
- Interactive (GUI) mode / command line mode;
- Saving data into a PostgreSQL Dump, 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 as the program works with direct access to PostgreSQL server not through ODBC like other similar converters.
- Skins support.
- Multilanguage Support
Requirements:
- Windows XP/2000/NT (with Internet Explorer 4.01)
- At least 32 MB of RAM
- Necessary privileges to write into database on the target PostgreSQL server.
Important notices:
- Does not convert system (hidden) tables.
- Does not convert relationships between tables.
Application stages
- Start - how to start.
- Process stages - stages of conversion process.
- Registration - how to register.
- FAQ - if you still have questions, which were not highlighted in the previous sections, or experience troubles in using the application, please, check the Access2PostgreSQL Pro FAQ page out.