Postgres Pro ProGate
Up to 80 TB/day
migration throughput from PostgreSQL to Postgres Pro
6+ migration paths
support for Oracle, PostgreSQL, Postgres Pro, Parquet, and more
Up to 40 TB/day
migration throughput from Oracle to Postgres Pro
Single interface
centralized management and monitoring of all tasks via a convenient GUI and API
Benefits of Switching
Fast Data Migration
Reduces data transfer time and optimizes resources when moving from legacy databases to target systems.
Risk Mitigation
High compatibility of ProGate with Postgres Pro minimizes failure risks, reduces the chance of data loss, and makes the migration process more predictable and secure.
Transparent Control
Real-time monitoring and management of migration projects at every stage.
Lower Implementation Costs
An intuitive interface and a high level of automation reduce the onboarding time for DBAs and project teams during migration.
Scalable Architecture
A distributed task-processing system with horizontal scaling capabilities.
Migration Quality Verification
Ensures data integrity after transfer through built-in validation mechanisms.
Core Features
Connections
- Connection list
- Create a connection
Data Transfers
- Select source and target for data transfer and configure basic execution options
- Simplified setup for migration and replication
- Advanced ProCopy configuration
- Create «schema-to-schema» tasks
- Automatic database object mapping
- Create «SQL query» tasks
- Automatic mapping of SQL query results to target database objects
- Task list
- Data transfer overview
- Data transfer list
Monitoring
- Data transfer execution status
- Execution logs for data transfers
Key Capabilities
Working with Large Data Volumes
- ProCopy High-speed transfer of database objects (initial load).
- ProSync Low-latency change replication (Change Data Capture).
- Multiple Source Support Oracle Database, Postgres Pro, PostgreSQL, Parquet files, and other databases/storage systems.
- Parallel Object Transfer Horizontal scaling of replication to handle terabytes of data.
Performance and Scalability
- Parallel Processing ProCopy loads data in multiple threads and splits tables into segments, enabling fast migration even for very large databases.
- Optimized Startup Process ProCopy and ProSync can run in parallel, reducing the migration downtime window and allowing operations to continue without long pauses.
- Incremental Loads Transfers only new and modified data without full table copies, lowering system load and speeding up the process.
- Large Transaction Support Reliable transfer and commit of high-volume transactions in heavily loaded systems without data-loss risk.
Reliability
- Failover and Automatic Recovery Automatic task restart after failure, no manual intervention required.
- Flexible Architecture ProGate can be deployed on any machine involved in migration (Oracle host, Postgres host, or a separate node).
- Integration Native integration with Postgres Pro for maximum performance and stability.
- Quality Verification Post-migration integrity and data quality checks.
- Distributed Architecture Distributed design with horizontal scaling capabilities.
Manageability
- Interactive Dashboards Real-time monitoring of all processes.
- API for DevOps Integration Connect to CI/CD pipelines, scripts, and enterprise systems.
- Notifications and Alerts Event-based incident and task-status notifications.
- Graphical Configuration Interface Unified GUI for all operations from route configuration to execution control.
Migration and Replication Capabilities
Tool |
Sources |
Targets |
Tasks |
|---|---|---|---|
| ProCopy | Oracle, PostgreSQL, Postgres Pro, Parquet, etc. | PostgreSQL, Postgres Pro, Parquet, etc. | Full data migration |
| ProSync | Oracle, PostgreSQL | PostgreSQL, Postgres Pro | Replication and CDC |
| ProCheck | Oracle, PostgreSQL, Postgres Pro | Data comparison and integrity verification |
FAQ
How does ProGate help reduce migration time?
ProGate supports predefined replication routes, automated tasks, and incremental data loading. This allows migration timelines to shrink from months to days or even hours.
Can ProGate be used for continuous replication, not just one-time migration?
Yes. ProGate supports both full migrations and ongoing replication across different systems, including cloud and on-premise environments.
Can ProGate be used without containers or complex integrations?
Yes. ProGate is delivered as installable packages and can be deployed on any machine without mandatory containers or external dependencies.
Do I need to stop the system to transfer data?
No. ProCopy and ProSync can run in the background on live databases, enabling data transfer without interrupting core business operations.
A short downtime is required only during the final sync via ProSync and when switching applications to the new database.
What new sources and targets are planned for future releases?
The ProGate roadmap includes support for Microsoft SQL Server, MySQL, and other databases as sources, as well as OLAP platforms, Shardman, and message queues as data targets.
What resources are required to deploy ProGate?
A DevOps engineer and a database administrator are sufficient. ProGate does not require specialized hardware or third-party licenses beyond those used for source and target databases.
Get Expert Assistance
Submit a consultation request — a Postgres Professional expert will contact you, provide an online session, and recommend the best solution based on your requirements.