Learn more about

database-migration
Introduction to the 12-step Migration and Modernization Methodology

At ABCloudz, we know that a successful migration or modernization project relies on a solid foundation and a well-defined approach. Our approach is encapsulated in the 12-step Migration and Modernization Methodology, which we’ve developed and refined over 20 years of practice. It has proven so effective that it was adopted by AWS to guide their cloud migration best practices.To illustrate this methodology in detail, we’ve created a series of four blog posts, each covering a critical phase of the migration […]

Adam Robertson
Migration Solution Document Capturing the Project Roadmap — Part 4

Welcome to the fourth and final blog post in the overview series dedicated to our 12-step Migration and Modernization Methodology that was adopted by AWS. We started by defining workloads and examining their interdependencies, which set the stage for capturing the current architecture and designing the future state architecture as part of the first step of the methodology — Future State Architecture Design. Next, we focused on gathering and analyzing project artifacts to inform a detailed effort estimation and project […]

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

Adam Robertson
Workload Definition Shapes the Migration & Modernization Roadmap — Part 1

Welcome to the first blog post in the overview series dedicated to our 12-step Migration and Modernization Methodology that was adopted by AWS. In any migration or modernization project, it’s crucial to start with a clear understanding of the system’s components and their relationships. This is where workload definition comes into play. Defining workloads correctly sets the stage for the entire project, making it possible to scope, assess, and plan each step with precision. Workload definition is one of the […]

Adam Robertson
Migrating from Oracle to SQL Server for a food manufacturing company

ABCloudz recently helped The Morning Star Company, one of the world’s largest producers of tomato products, migrate their Oracle database to SQL Server. The Morning Star Company operates three processing facilities in California, handling nearly 10% of the global tomato production. Their IT infrastructure included both Oracle and SQL Server databases, but due to the high cost of Oracle licenses, the company decided to gradually retire their Oracle servers and migrate to SQL Server. They reached out to ABCloudz for […]

Oleksii Savchenko (DB Developer), Oleksii Svitlychnyi (Technical writer)
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 constructs efficiently. In these cases, manual adjustments and optimizations are required to ensure a seamless transition to the target database. At ABCloudz, our team has […]

Oleksii Svitlychnyi
Database migration with SSMA: Handling typical conversion issues

Migrating databases from Oracle to Microsoft SQL Server can be a complex endeavor, especially when it comes to dealing with differences in schema structures, data types, and specific SQL clauses. The SQL Server Migration Assistant (SSMA) is a robust tool designed to automate these migrations and minimize manual effort. However, SSMA might not always produce optimal results, and understanding how to overcome these limitations is crucial for a successful migration. At ABCloudz, we’ve encountered these challenges firsthand. Through our experience, […]

Oleksii Svitlychnyi
Handling PostgreSQL Routines with More Than 100 Arguments

When working with PostgreSQL, database developers may encounter a limitation when attempting to create routines with more than 100 arguments. PostgreSQL enforces this restriction by setting FUNC_MAX_ARGS to 100 during the server build. Although this limitation is rarely an issue, complex procedures, particularly those migrated from Oracle, may have a significantly higher number of arguments. This blog post outlines a solution to handle such situations by utilizing composite data types to bypass the argument limit, ensuring routine compilation without significant […]

Oleksii Savchenko
Optimizing Date and Time Conversion in Oracle to SQL Server Migration

Migrating databases from Oracle to SQL Server can be a daunting task, especially when dealing with date and time data. While tools like the SQL Server Migration Assistant (SSMA) offer automated solutions, relying solely on these tools might not always yield the best performance. In this blog, we share examples of how to optimize conversion of Date and Time Conversion functions, after it was generated by SSMA. Key differences between Oracle and SQL Server Oracle and SQL Server handle date […]

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 functions correctly post-migration. For example, consider the following transformations: Oracle PostgreSQL SELECT sysdate FROM dual; SELECT aws_oracle_ext.sysdate() SELECT to_char(sysdate, ‘dd.mm.yyyy hh24:mi:ss’), to_char(sysdate, ‘dd.mm.rrrr’) FROM dual; […]

Oleksii Savchenko
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

Hi there! How can I help you?

ABCAssist