More from our Blog
SaaS Platform Modernization and Database Migration to PostgreSQL on Amazon RDS
Executive Summary Challenge: To modernize its Project and Portfolio Management (PPM) SaaS platform, OpenText (formerly Micro Focus) made the call to shift its products from on-premises Oracle servers to PostgreSQL on Amazon RDS. They faced various hurdles due to inconsistencies within the database and the legacy architecture of their app. They also requested a reusable […]
Alexander Gora
Custom data migration solution for a complex Oracle to PostgreSQL migration project using AWS DMS
In this post we’d like to share with you our experience in delivering a sophisticated database migration solution on top of AWS DMS for one of our large enterprise customers. The client is a large technology corporation that provides software solutions and services for telecom giants and mid-size companies. They ran numerous Oracle databases where […]
Alexander Gora
Data management strategy: How to reduce costs and eliminate downtime
Data infrastructure is what powers the proper performance of your software. However, unexpected issues can occur making your system unavailable. That’s where the notion of a downtime, a time period when the system is not available, comes in. Downtime may have different causes and outcomes. But one thing is certain, downtime can be extremely expensive. […]
Sergii Zymbytskyi
Oracle to PostgreSQL migration with AWS SCT: How to handle unsupported NumToDSInterval function
In this post we continue exploring the technical aspects of Oracle to PostgreSQL migration using AWS SCT. We were using AWS SCT build#660 to convert one of our Oracle test databases. AWS SCT provides functionalities for the most efficient migration from Oracle to PostgreSQL. However, there is a common challenge with implementing the Oracle NumToDSInterval […]
Oleksii Savchenko
Oracle to PostgreSQL migration with AWS SCT: How to convert INSERT ALL statement
In this post we continue exploring the technical aspects of Oracle to PostgreSQL migration using AWS SCT. AWS SCT promises a very high level of migration efforts, however it is very rare that 100% automation is achieved. In this article we’ll look into conversion of INSERT ALL statements, which are quite popular in Oracle code. […]
Oleksii Savchenko
Oracle to PostgreSQL migration with AWS SCT: How to handle unsupported data types
In this post we explore the technical aspects of Oracle to PostgreSQL migration using AWS SCT. We’ll look into conversion of Oracle “aliases”. We were using AWS SCT build #660 to convert one of our Oracle test databases. The challenge Oracle’s subtype declaration allows creating an “alias” for some datatype declaration, which can be re-used […]
Oleksii Savchenko
Ready to start the conversation?
ABCloudz emerged from the world of data and established itself as a go-to partner for any IT needs. Our professionals are ready to help. Drop us a line today!