Customer Stories
Company D
Enterprise Cloud Migration
Successful Oracle-to-PostgreSQL Data Migration
Cloud migration from Oracle with a data migration solution for stable transition.
- ClientCompany D
- ProjectPublic Cloud Migration
- IndustryManufacturing
- SolutionsAP#, SQL#, META#, ETT#
- HighlightsEnterprise Cloud migration, RDBMS to PostgreSQL
AS-IS Analysis for Cloud Migration
Structured Data Migration with a Specialized Solution
Company D migrated its enterprise databases from Oracle to PostgreSQL and used DATAWARE™ ETT# for a stable transition.
- Objectives
-
- Reduce costs and improve system performance
- Improve resource utilization and operations
- Successfully migrate from Oracle to PostgreSQL
- Key Features
-
- Cloud migration of enterprise systems and web services
- PaaS and DevOps environment adoption, Architecture aligned with security policies
- Successful Oracle-to-PostgreSQL migrations
- Reduced migration time and cost with ETT#
- Technology
-
- AS-IS / TO-BE: Oracle 10g → Azure Database for PostgreSQL 10
- Migration Objective: Reduce costs, improve performance and resource efficiency, and modernize development and operations.
- SQL Conversion Period: Jan-mid-Feb 2019
- Conversion Process: XML conversion → SQL extraction and execution → Error correction → Revised XML delivery using SQL#
- Data Migration: 7 hours using ETT# integrated with Ora2pg (open-source tool)
