EMS Data Pump for PostgreSQL is a migration utility designed to convert database structures and import table data from any ADO-compatible source (such as MS Access or MS SQL) to PostgreSQL databases. It provides a user-friendly wizard interface for building connection strings, selecting schema objects, customizing target database structures, and automating migration tasks via command-line utilities. The tool supports both structure and data conversion, offering flexibility and full process monitoring for database administrators and developers25.

Key Features

User-friendly Wizard Interface Guides users through the migration and import process.

• Simplifies building ADO connection strings.
• Step-by-step selection of tables, fields, and indexes.

Flexible Source and Target Support Handles various data sources and PostgreSQL targets.

• Converts from any ADO-compatible database (local or remote).
• Allows creation of new or connection to existing PostgreSQL databases.

Customizable Conversion and Import Enables detailed control over migration.

• Select specific schemas, tables, fields, and indexes.
• Edit, execute, and save SQL scripts for target database structure.

Automation and Scripting Supports unattended and repeatable migrations.

• Command-line utility for automated jobs using template files.
• Save and reuse migration templates.

Advanced Connectivity Secure and versatile connection options.

• Connects to PostgreSQL via SSH or HTTP tunnel.
• Unicode data support and multilanguage GUI.

Monitoring and Logging Ensures transparency and control.

• Full monitoring of the pumping process.
• View and edit migration parameters.

Benefits

Streamlined Database Migration Reduces complexity and manual effort in moving data to PostgreSQL.

• Automates repetitive migration tasks.
• Minimizes errors through guided workflows.

High Customizability Adapts to varied migration scenarios and requirements.

• Fine-grained selection of objects and data.
• Customizable SQL script generation.

Enhanced Productivity Saves time for database administrators and developers.

• Templates for recurring migrations.
• Command-line automation for integration into workflows.