Oracle to PostgreSQL Migration

Description:


  • Delivers comprehensive assessment reports to present how your system can be migrated and optimized

  • Analysis, implementation, and migration done by fully experienced team to ensure all migration process running smoothly without any hassle

  • Advanced technique and methods, so downtime is minimized as high as possible
If you want to migrate your existing system, please take our
Migration Pre-liminary Questionnaire
Migration to PostgreSQL

Migration Services

Oracle to PostgreSQL Migration Services
Professional Services to help you migrate to PostgreSQL

Our Professional Services do not only cover Maintenance and Managing your PostgreSQL Database, but also support to migrate your existing Oracle system to PostgreSQL. This Professional Services include multiple stages from Pre-liminary and Comprehensive Assessment, Strategic Analysis, Structure and Logic Conversion, and Comprehensive Migration Rundown. Our expert team will deliver the precise yet prudent solutions for migrating Oracle to PostgreSQL.

Migration Stages

We help you to migrate your current Oracle database to PostgreSQL without hassle. Combining sophisticated technique and professional expertise, ensuring your application can run smoothly after migration.

# Description

Migration Assessment Stages

1

Preliminary Assessment

It takes arround 2 days to analyze all the database Objects briefly to get some ideas on how long it take to do Comprehensive Assessment. Look for potential Stopper: System Functions, Customization possibility, Specific Function/Datatype, Allowable Downtime, Any potential copyright infrigment, etc. Develop Mitigation, solution and possibility workaround.

2

Comprehensive Assessment

Assess all the object mentioned in the scope of work, very detailed. Produce Comprehensive Assessment Report, consist of:
  1. Level of Difficulties
  2. How many Mandays Effort
  3. Migration Schedules
  4. Proposed Migration Rundown
  5. Analysis Report

Schematic Migration


Most of the Structures are compatible with PostgreSQL (even not 100%). Prepare the “bucket” first, then the “water”
1
Dump all database object structures (tables, sequences, views, etc.)
2
Check whether specific data types should be converted
3
User Defined Types should be deeply examined
4
Constraints (PK, FK, Uniqueness, Indices) will be recreated in PostgreSQL, as long as Database Object Relationship is kept consistent

Data Migration - Analysis


Migration Data from Oracle to PostgreSQL is dealing with downtime and ETL, and somehow it needs very fast.
1
How much is the Downtime tolerance
2
Housekeep data from Oracle Source Database
3
Doing Stress Test to the pre-migrated data
4
Using FDW/ETL Tools, it is possible to start synchronizing data without interrupting current Transactional Process on Source Database

Logic Migration - Analysis


Logic conversion is the PAIN, when doing migration. Requires a deep understanding on how the function works.
1
Streamline the Logic
2
How many total line of codes used on Stored Procedures/Functions/Packages
3
Doing Stress Test to the pre-migrated data
4
Is there any Oracle specific functions used?
5
Create a mimic for called functions, as long as output is the same
6
PostgreSQL is highly extensible platform, if not supported yet, we can create it as long as we have the expertise
7
Do System Integration and Regression Test with application

System Migration - Analysis

1
How long downtime can be tolerate by Management?
2
Based on the finding from Data Migration, we can understand how long it take to migration the live data, this is the main consideration to develop Rundown System Migration
3
How many Instance Application involve in the System Migration?
4
How many party involved in System Migration?

List of PoC (Proof of Concept) Portfolios

As a Leading IT Solution Provider in Indonesia, we are strongly confident in delivering our solution and technology. Time to time our client wanted to see the best implementation and test the great solution that we offer to their needs. We are more than happy to serve our Clients and Partners, to conduct Proof of Concept on their premises for their sample production data and system. We love to see their great smiles on their successful of PoC according to the scenario and aligned with the prepared Rundown.

Lotte Mart

Equnix team has done Proof of Concept for Data Warehouse System using Deepgreen and also replication implementation with ArkCDC on Lottemart Indonesia. There are two dozens of tables extracted and synchronized, where the biggest table has around one billion rows, and total synchronized data is almost one Terabytes. While the hardware specifications are not the same with the data source, our test server hardware is much lower than the Oracle one, but still, it gave great results. Some queries are more than 20 times faster, where on Oracle it run about an hour and half and on Deepgreen, it run less than three minutes for around two third million rows. In this POC also demonstrated ArkCDC to replicate data from Oracle database to PostgreSQL database. ArkCDC can directly access redo log on the Oracle database and it will make the data extraction very fast and guarantees that the data consistency by analyzing file format and directly extracting changed data. On the demo from the Oracle server, user inserted about thousands of rows data and then inserted another thousands rows of data. The records are immediately replicated to the Deepgreen within 12 seconds.

Reporting Queries Comparison
No Query Report Name Oracle (in minutes) Deepgreen (in minutes) Speed Gain Total Row Count
1 Report1 85 2.8 21500% 663.034
2 Report2 25 2.4 830% 104
3 Report3 7.5 3.3 2121% 383.359
4 Report4 120 10 1200% 154

Pengadaian

Equnix team has done Proof of Concept for Data Warehouse System using Deepgreen on PT Pegadaian by doing Extraction Transform and Load from DB2 Database to Deepgreen. There are dozen of tables that the data have been loaded and synchronized to Deepgreen, where the biggest table has about half billion rows, and total synchronized data is around two fifth Terabytes. Equnix has presented the progress results of the POC by testing insert reporting queries submitted by Pegadaian Team. Compared with execution time on DB2 database, the reporting queries run very fast in Deepgreen. On DB2, the query has execution time around 25 minutes and on Deepgreen the execution time is around 31 seconds, it’s 48 times faster on Deepgreen. For further details, please check on the report below.

Reporting Queries Comparison
No Query Report Name Oracle (in minutes) Deepgreen (in minutes) Speed Gain Total Row Count
1 Report1 17 3.5 485% 33741
2 Report2 11 1.2 916% 15
3 Report3 13 1.6 812.5% 13

Telkom Akses

Equnix team has done Proof of Concept for Data Warehouse System using Deepgreen with also implementing ETL Tools to extract data from Oracle Database to Deepgreen on Telkom Akses Indonesia. There are dozen of tables that the data have been loaded and synchronized to Deepgreen, where the biggest table has about a quarter hundred million rows. Equnix has presented the progress results of the POC by testing reporting queries submitted by Telkom Akses. Compared with execution time on Oracle database, the queries run 20 times faster on Deepgreen with result for almost half million rows.

Reporting Queries Comparison
No Query Report Name Oracle (in minutes) Deepgreen (in minutes) Speed Gain Total Row Count
1 Report1 37 4.8 770% 408.122
2 Report2 33 19.6 173% 233.291
3 Report3 2 0.4 500% 24.338
4 Report4 17 0.7 2420% 465.676

Astra Pay

Equnix team has done Proof of Concept of CubeOne as on of enterprise encryption solution for PostgreSQL. Equnix provided the environment for testing to Astrapay team, and they have done the testing by integrating with the application.

Materials

*The published PoC reports are for 2020 PoC activities. There still more PoC reports from before 2020 to be published in the future.

*Not all materials are ready to be published, we will update time to time. Please visit the page again later.

Photos