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 state architecture as part of the first step of the methodology — Future State Architecture Design.This provided a solid foundation for understanding the scope and […]

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 mean for you? Attaining the Migration Competency sets ABCloudz apart as an AWS Partner with a proven ability to smoothly migrate clients of all sizes […]

As a leading service provider in the realm of digital transformation and database management, ABCloudz has attained its second AWS Service Delivery Partnership designation and now holds the status of an AWS Database Migration Service (DMS) Delivery Partner. This achievement is a resounding reflection of our company’s exceptional proficiency in providing the highest-quality Amazon cloud solutions to our clients. It solidifies our technical competence, underscores our commitment to excellent customer service, and reaffirms our established position as a reliable AWS […]

ABCloudz, a leading company in digital transformation and database management, has achieved the RDS Service Delivery Specialization and is now an AWS Service Delivery Partner. This designation is a testament to companies with AWS partnership that have proven themselves in delivering high-quality Amazon RDS solutions through their expertise, technical capabilities, and exceptional customer service. Why did we step on a path of AWS Service Delivery Partnership ABCloudz went through an assessment process to become an AWS Service Delivery Partner, where […]

ConcertAI, one of the leading providers of medical research software, faced a common scenario for a mature healthcare data center. Over the years, its infrastructure had become highly sophisticated but inconsistent. Some of the servers were running outdated, end-of-life operating systems and urgently needed upgrading. The client decided to implement a cloud-based solution for infrastructure migration and partnered with ABCloudz to make the system more manageable and prepare it for upcoming refinements. Our specialists suggested moving to AWS due to […]

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 understanding of building software solutions while having outstanding achievements of remarkable customer experiences. This AWS partnership is a direct result of the company’s constant efforts […]

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. One hour of system downtime can cost you more than $300,000. And, apart from direct losses, it is extremely damaging to your reputation. Especially when […]

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 function in PostgreSQL. The Oracle NumToDSInterval function is responsible for the conversion of the provided number value of specified time units or expressions to an […]

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 retrieve an entire result set and store it in a PL/SQL collection type variable in a single operation. This can be completed with a SELECT […]

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 types is no longer needed. Normally, we define the CURSOR variable of a weak type with Oracle SYS_REFCURSOR datatype. This applies to the cases when […]

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. We were using AWS SCT build #660 to convert one of our Oracle test databases. Oracle gives you an option to use the conditional insert […]

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 later as many times as needed. PostgreSQL domains entirely differ from Oracle’s subtypes. Thus, whenever you try to convert PL/SQL code containing variables that are […]