EMS Data Pump for PostgreSQL

What is EMS Data Pump for PostgreSQL?

EMS Data Pump for PostgreSQL is an excellent migration tool for converting databases and importing table data from an ADO-compliant source (for example, MS Access, MS SQL database, or any other ADO-supported database) into PostgreSQL databases.

The easy-to-use wizard application lets you create the ADO connection string, select tables, fields, and indexes to convert, view, and edit SQL scripts to generate the target PostgreSQL database and fully customize the import process. Data Pump for PostgreSQL has the ability to automate the migration to the PostgreSQL server task using the useful console utility. With Data Pump for PostgreSQL, converting and migrating the database to PostgreSQL becomes as easy as possible!

Core features

• Wizard-friendly interface.
• Ability to create a new PostgreSQL database or connect to the existing one.
• Converting structure and data from any local and remote data source with an ADO provider.
• Unicode media.
• Selecting schemas, tables, fields, and source indexes for conversion.
• Quick generation of tables, fields, and indexes according to the structure of the source database.
• Easily customizable options for target database objects.
• Ability to view/edit, run and save SQL scripts to generate the target database structure.
• Selecting tables and defining criteria for data import.
• Complete monitoring of the pumping process.
• Ability to save all parameters specified in the current wizard session as a template.
• Multilingual GUI support.
• Command-line utility to automate data pump work with the help of a model file.
• Ability to connect to the target PostgreSQL server via SSH or HTTP tunnel.

System requirements

300 MHz processor; Recommended 600 MHz (MHz) processor

Microsoft® Windows NT4 com SP4 ou posterior, Microsoft® Windows 2000, Microsoft® Windows 2000 Server, Microsoft® Windows XP, Microsoft® Windows 2003 Server, Microsoft® Windows 2008 Server, Microsoft® Windows Vista, Microsoft® Windows 7, Microsoft® Windows 8, Microsoft® Windows 8.1, Microsoft® Windows 10

64 MB of RAM or more; 128 MB or more recommended

20 MB of available HD space for program installation

Super VGA (800x600) or higher resolution video adapter and monitor; Super VGA (1024x768) or higher resolution video adapter and monitor is recommended

Microsoft mouse® or compatible pointing device

Possibility to connect to any local or remote PostgreSQL server as a destination and an ADO-compliant source