PostgreSQL to MS Access Migration and Sync

Fast, flexible and customized cross database migration and synchronization from PostgreSQL Server to MS Access.

PostgreSQL as a server database is used for storing consolidated data in one place on a daily, weekly or monthly basis. But sometimes if there is no way to share this data through web or the task is to provide partial data as per user requirement in specific time. Using MS Access database as an intermediate storage for your clients would be a perfect solution.

Our solutions are full of options to make data exchange job between PostgreSQL and Access fast and customized to your needs.

Specify whether or not to include tables, fields and indices, change data types, and specify subsets of schema objects to migrate or all.

Integrated Data filters allow extracting specified data only and passing them to target database smoothly.

Read here trial versions limitations

Product highlights

• Saving data into a PostgreSQL Dump and PHP script for export to PostgreSQL database
• Direct access to PostgreSQL server, not through ODBC like other similar converters
• PostgreSQL schemes support
• Ability to connect to PostgreSQL 9.x/7.4 located on Linux, Solaris, Mac OS X, Window machines
• Speed conversion with Bulk and Quantization features
• Access queries to MS SQL, MySQL and PostgreSQL views conversion support
• MS Access Work Groups support
• Linked tables support
• Also see common features for all DBConvert tools

Requirements

• Necessary privileges to write into database on the target PostgreSQL server (this requirement is optional as there is an option to overcome the restrictions using dump file or PHP Script)
• Access 2000 or higher
• Microsoft Visual C++ 2008 x86 Redistributable package