Learn more about

database-migration
Fault-tolerant algorithm for migrations from MySQL to MongoDB

When it comes to seamless data system management, our international IT client needed a solution to migrate their client’s legacy MySQL solution to a fully-managed MongoDB environment. Our team at ABCloudz was up for the challenge and delivered a fault-tolerant algorithm that ensures the migration process is reliable and user-friendly. The need for fault-tolerance and simplicity To achieve this, our customer required a solution that could automatically restart the migration from where it halted in case of any disruptions during […]

Oleksandr Gora
Sophisticated migration of an IT infrastructure from on-premise data center to the AWS cloud

ConcertAI, one of the leading providers of medical research software,  has faced very common scenario for a mature healthcare data center as its infrastructure had developed over years to become extremely sophisticated but highly inconsistent. Some of the servers were running on an end of life OS and desperately 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 prepared for the upcoming refinement. Our specialists […]

Alex Smirnov, Roman Muzyka
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 they stored billing and other financial data. In an effort to cut costs for operational infrastructure, the company started the migration of their Oracle systems […]

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. 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 […]

Sergii Zymbytskyi
Migrating healthcare app databases from AWS Datica to independent AWS servers

A modern medical company was running a large healthcare platform connecting patients with medical imaging providers. They had databases for the admin app, patient app, physician app, and the original service portal. All these databases were running on AWS cloud servers deployed and managed by Datica. The latter helped the customer scale and manage their data infrastructure and had control and access to their data. However, the customer wanted to go beyond the Datica service offer. They wanted to gain […]

Viacheslav Kim, Marat Razzakov
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 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 […]

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 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 […]

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, interval values appear when it comes to dealing with dates. The challenge MySQL partially supports intervals. However, it doesn’t support storing values of this type […]

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 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 […]

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. 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 […]

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 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 […]

Oleksii Savchenko
Quick and easy automatic approach to database conversion

One of the largest educational organizations in the United States had been running their data handling system in the Oracle environment. They wanted to reduce maintenance costs due to the expensive Oracle licensing model, which includes an additional fee for the partitioning feature. The ABCloudz team provided a solution for migrating the customer’s database to SQL Server. Reconstruction of the original partitioning system in SQL Server allowed us to significantly lower SQL Server maintenance costs compared to Oracle. Check out […]

Andrey Khudyakov, Roman Muzyka
An overview of the remote migration from Oracle to SQL Server with SSIS

One of our clients, a large financial software company, wanted to migrate their billing solution from Oracle to SQL Server. They needed to initiate this project because the migration was required by one of their strategic partners. The customer decided to implement SQL Server Integration Services (SSIS) for this migration. Additionally, they needed to do the data transfer from Oracle to SQL Server. Because of the complexity of the project, the client sought software developers that would build an automated […]

Andrey Khudyakov, Roman Muzyka
Conversion of Oracle schemas with hierarchical queries to SQL Server

One of our clients, prominent information technology company, needed to migrate its Oracle database to SQL Server so they called ABCloudz. They knew they wanted to automate the major part of the migration with SQL Server Migration Assistant (SSMA) but there were some challenges associated with this process. First, the company’s source database code contained over 400 hierarchical queries that could not be converted with SSMA. And second, the company’s technical staff was also unable to convert such queries. By […]

Andrey Khudyakov (DB architect), Roman Muzyka (writer)
Use caution when mapping Oracle data types for procedures and function parameters in SSMA

Mapping Oracle data types to SQL Server data types is often a problem during Oracle to Microsoft SQL Server database code conversions. A tried and trusted solution is to use an SQL Server database code conversion. Another reliable solution is to use SQL Server Migration Assistant. These solutions enable you to automate Oracle database conversions to SQL Server. However, there might be some issues you should consider while using SSMA. For example, by default, SSMA applies the maximum available size […]

Andrey Khudyakov (DB architect), Roman Muzyka (writer)

Hi there! How can I help you?

ABCAssist