More with tags:

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

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

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

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

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

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

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

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

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

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

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

A materialized view is an important property of Oracle. SQL Server recreates the same behavior as this materialized view in several ways. Unfortunately, SSMA may have issues with converting this object to SQL Server. It flags certain conditions as an error. In this blog post, we will overview the error O2SS0522. It goes about cases in […]

ABCloudz tech experts possess outstanding experience in migrating databases. For this purpose, we frequently use SQL Server Migration Assistant (SSMA). SSMA utilization may cause various types of errors, so we have created a blog post series which focused on typical database conversion errors. Each post in this series is dedicated to a separate problem statement and […]

Oracle enables you to use specific interval literals for indicating a certain period of time. Unfortunately, there is no direct analog for such literals in SQL Server. As a result, when you apply SQL Server Migration Assistant (SSMA) for converting Oracle code with interval literals, you receive an error O2SS0086. The term ‘interval literals’ refers to a fixed data value, […]

With Oracle table functions, you can define a set of PL/SQL statements in such a way that, when queried, should behave just as a regular query to the table. The table function enables you to manipulate individual collection elements (user-defined object types) in your SQL database code. However, this may create a database migration challenge […]