ASSESS10 business days
Oracle → PostgreSQL Readiness Report
We analyse schema, PL/SQL and application dependencies.
Deliverable: Portability score and savings estimate
01 Assess02 Migrate03 Operate04 Protect05 Create value
Database Migration
Shed the licensing burden and migrate without losing data.
From Oracle to PostgreSQL, from DB2 to cloud data services: we run schema, PL/SQL and data migration in sync with CDC, fitting downtime into a planned window.
Who is it for?
If any of these statements sound familiar, you are in the right place.
Oracle and DB2 licensing costs rise with every renewal.
Modernisation has been postponed for years because of migration risk.
Converting thousands of lines of PL/SQL code by hand does not seem realistic.
Scope of services
What do we do in Database Migration?
Oracle → PostgreSQL
Move to open source through schema and PL/SQL conversion, backed by our EDB Platinum Partner status.
IBM DB2 → PostgreSQL
Migrating DB2 workloads to modern platforms.
PostgreSQL → MySQL / MongoDB
Migration between relational and document databases according to application needs.
Exadata → BigQuery
Migrating data warehouse workloads to a cloud analytics platform.
AnyDB → AnyDB
Automating schema and code conversion through our partnership with Ispirer.
Near-zero downtime with CDC
Synchronised data flow through initial load and change data capture.
Solution details
Our Database Migration solutions
You can find the detailed scope, method and measurable commitment of each topic on its own page.
From Oracle to PostgreSQL
What do you gain, and what should you watch out for?
Not every workload is suitable for migration; that is why we start by measuring which ones can be migrated, not by migrating.
What do you gain?
- Per-core licensing and the annual support line item disappear
- Independence in choosing versions, distributions and support providers
- Managed PostgreSQL options on every cloud provider
- Geospatial data, JSON and an extension ecosystem
Honest risks
- If most of the business logic lives in the database, the effort rises significantly
- Third-party applications cannot be migrated unless the vendor supports it
- Some Oracle features have no one-to-one equivalent and require redesign
- Post-migration performance tuning is a separate phase
Migrations we have delivered
Platform migration examples
- Oracle → PostgreSQL / EDB / AlloyDB
- SQL Server → MySQL / MariaDB / PostgreSQL
- On-premises → Google Cloud / AWS RDS / Azure SQL
- Exadata → BigQuery
- IBM DB2 → PostgreSQL
Measurable commitment
The assessment report places every object to be migrated into one of three categories: converts automatically, needs manual intervention, requires redesign. The effort estimate is derived from this count. If the outcome is negative, we do not recommend migrating; instead, we focus on licence optimisation of the existing Oracle environment.
How we work
Every step ends with a measurable output and a decision point.
Discovery and inventory.
Mapping the current environment, dependencies and workloads.
Assessment.
Compatibility analysis, target architecture and effort estimate.
Schema and code conversion.
Converting schema, PL/SQL and application code to the target.
Data migration and CDC.
Synchronised data flow through initial load and change data capture.
Testing and validation.
Functional testing, performance testing and data reconciliation.
Cutover and Go-Live.
Cutover within the planned downtime window and go-live support.
Technologies and tools
Platforms we work with
Oracle DatabasePostgreSQL / EDBExadata / ExaCCBigQueryAlloyDBMongoDBIspirerStriimDebeziumGoogle DMSmigVisorOracle GoldenGateData Pump / XTTS
Quick start
Packages to get started in this area
MIGRATE6 weeks
Pilot Migration
We migrate a non-critical database to PostgreSQL end to end.
Deliverable: Your first migrated system running in production
Continue the journey
Frequently chosen alongside this area
Database Management
24/7 SLA-backed operations for Oracle, Exadata, PostgreSQL, SQL Server and MongoDB.
ExadataEDBOEM
Learn more →Cloud Management
Google Cloud and OCI maintenance and support, cloud migration, multi-cloud, landing zones and FinOps.
Google CloudOCIFinOps
Learn more →Analytics & Business Intelligence
Data warehouse, data lake and BigQuery; fast dashboards with Vispeahen and SU BOP.
BigQueryVispeahenSU BOP
Learn more →Next step
A no-commitment start in three steps.
01
Discovery call
We spend 45 minutes understanding your environment and priorities. Free of charge.
02
Free initial assessment
After the meeting, a one-page note with initial findings and recommendations; the findings are yours to keep. A full health check and risk report are part of our accelerator packages.
03
Package or service
Start with an accelerator package or go straight to managed services.