abcloudz

The flow and value of business analysis at ABCloudz

The application development process is a multi-layered activity with the core idea as the starting point and a well-functioning final product as the top layer. In this post, we will focus on the twists and turns involved in bringing the idea through to the final product. The role of business analysis is to identify and bring together […]
Vlad Kalinichenko

Why Use Microservices Architecture?
A Practical Guide

What is a Microservices Architecture? Microservices architecture is a style that structures an app as a set of predetermined services. At its core, such app is split into smaller independent segments that perform their own functions. This approach permits to view microservices as a group of undivided apps that handle their own features. As a […]
Maevskiy Konstantine, Starov Yevgen

Why Use Monolithic Architecture?
A Practical Guide

What is monolithic architecture? Monolithic architecture is known as a traditional approach to software development that is based on a single-unit design. This means that a program is basically a self-contained and independent unit. It consists of a database, client-side user interface, and server-side application. As it is possible to clearly see, a monolithic app […]
Konstantyn Maevskiy, Yevgen Starov

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

Expand capacity with an IBM DB2 SQL Azure SQL Database migration

One of the world’s largest distributors of non-food consumable products wanted to rationalize their data platform and business intelligence strategy. Their current IBM DB2 database system lacked a repository to host historical audit-related data, so they could hardly retrieve data from past years. Then we came up with an Azure cloud database solution that could […]
Andrii Koval

Preparing a healthcare application for HIPAA audit

HIPAA (Health Insurance Portability and Accountability Act) is one of the most important United States federal statutes which has a great impact on the development of medical software. This act stands for the safety of the protected health information (PHI) and defines security standards that each digitized medical business should follow. HIPAA sets numerous requirements […]
Kirill Karpenko, Roman Muzyka

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 […]
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 […]
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 […]
Andrey Khudyakov (DB architect), Roman Muzyka (writer)

Schema mapping in migration from Oracle to SQL Server

The migration of Oracle databases to Microsoft SQL Server brings many challenges. One of the most significant is associated with mapping Oracle schema to SQL Server. At the architecture level, the wrong approach will result in significant effort in the future. For example, you may even need to rewrite your app’s entire code from scratch. […]
Andrey Khudyakov, Roman Muzyka

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 […]
Andrey Khudyakov (DB architect), Roman Muzyka (writer)
...23456

Ready to start the conversation?

ABCloudz emerged from the world of data and established itself as a go-to partner for any IT needs. Our professionals are ready to help. Drop us a line today!

Hi there! How can I help you?