abcloudz

Learn more about

aws-sct

Analyzing Migration Project Efforts and Crafting the Project Plan — Part 3

Welcome to the third blog post in the overview series dedicated to our 12-step Migration and Modernization Methodology that was adopted by AWS. In our first and second blog posts, we explored the critical role of defining workloads in migration projects and laid out the process of capturing the current architecture and designing the future […]
Adam Robertson

Database migration with AWS SCT: Solutions for typical conversion issues

Migrating Oracle databases to PostgreSQL or MySQL with AWS Schema Conversion Tool (AWS SCT) can present a range of challenges, from unsupported data types to limitations in automated code conversion and potential performance issues. AWS SCT offers powerful capabilities to automate these migrations, but it may not always deliver optimal results or handle complex Oracle […]
Oleksii Svitlychnyi

Handling null and empty string differences in Oracle and PostgreSQL

When migrating from Oracle to PostgreSQL, one of the most important differences to consider is the treatment of null and empty string values. In Oracle, null and empty string are treated as the same entity, but in PostgreSQL, they are distinct. Failing to account for this distinction during migration can lead to logical errors and […]
Oleksii Savchenko

How to Optimize Oracle-to-PostgreSQL Migrations Using AWS SCT Extension Pack

The AWS SCT Extension Pack is designed to emulate Oracle’s system functions, procedures, and other database objects within PostgreSQL. This emulation is achieved by creating a special schema in PostgreSQL, named aws_oracle_ext, where these functions and objects are stored. This pack simplifies migration by replacing Oracle-specific calls with their PostgreSQL equivalents, ensuring that the code […]
Oleksii Savchenko

AWS Migration Competency Attained

Workload migration represents a pivotal milestone in the AWS customer journey, and our paramount focus is on facilitating a clear and seamless migration for our customers. Consequently, ABCloudz is thrilled to announce our recent achievement of the AWS Migration Competency, reaffirming our commitment to providing comprehensive and exceptional cloud migration solutions. What does this achievement […]
Adam Robertson

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

ABCloudz achieved Advanced Partnership status

ABCloudz — a global technology company with a full cycle of services, has become an Amazon Web Services (AWS) Advanced Tier Services Partner. The AWS Advanced Tier Services Partner status is a valuable accreditation for APN Technology Partners. It is granted to companies that have established expertise in AWS technologies and services and a proven […]
Adam Robertson

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 MySQL migration with AWS SCT: How to convert BULK COLLECT clause

In this blog post we continue covering AWS SCT conversion issues, adding to the series where we help developers to deal with complex migration issues that can’t be automated with SCT. Today we are going to look into how SCT Build #660 addresses the conversion of statements with BULK COLLECT clause. In Oracle, you can […]
Artem Avetyan

Oracle to MySQL migration with AWS SCT: How to handle unsupported NumToYmInterval function

Here’s one more insight into common code conversion issues while using AWS SCT build number 660. This time, we will tell you how to convert NumToYmInterval from Oracle to MySQL. Oracle has a NumToYmInterval function that converts the provided number value of specified expressions or time units to an interval year to month literal. Usually, […]
Artem Avetyan

Oracle to MySQL migration with AWS SCT: How to convert variables of SYS_REFCURSOR datatype

We continue our series of common issues pertaining to code conversions with AWS SCT. This time, we analyze the peculiarities of converting REF CURSOR types from Oracle to MySQL with the help of AWS SCT build number 660. In Oracle 9i, there is the predefined SYS_REFCURSOR type, which means that defining our own REF CURSOR […]
Artem Avetyan

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

Hi there! How can I help you?