Learn more about
aws-sct
modernization roadmap, application-modernization, database-migration, cloud-migration, database-conversion, Database conversion errors, SSMA, aws-sct, AWS Schema Conversion Tool, aws-dms, architecture, QA, Code conversion
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
aws-sct, aws, Database conversion errors, database-migration, Ora2Pg, Oracle to PostgreSQL migration, Oracle, PostgreSQL
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