postgresqlms access

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
PostgreSQL MS Access

Converter from
PostgreSQL to MS Access

  • 17 Jun, 2013
  • Version 4.2.5
ORDER From $149 DOWNLOAD 52.15 Mb

Synchronizer between
PostgreSQL and MS Access

  • 18 Jul, 2013
  • Version 4.1.3
ORDER From $149 DOWNLOAD 48.26 Mb

Two-way database migration in one package. Pay once - get both! Find more information about the reverse migration

From MS Access to PostgreSQL

Converter+Syncronizer Bundle! Take 25% off regular price

New Features

  • Queries conversion improvements.
    Now MS Access queries are converted more productively.
  • Large databases stable transferring: 500 thousand records can be converted/synchronized in 5-7 min.
  • SSL technique for encrypted data conversion support

Screenshots

PostgreSQL to MS Access: Benefits

  • 1 - Workaround for firewalls and access rights
  • 2 - Views conversion
  • 3 - Flexible customization for all db elements
  • 4 - Bulk and quantization for speed up of big volume of data processing
  • 5 - Conditional data migration
  • 6 - Full UNICODE architecture support
  • 7 - Optimal data mapping
  • 8 - Verification of potential migration issues
  • 9 - Command line mode & scheduling
  • 10 - Savable sessions