Learn more about

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

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

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

In Oracle, you can create a foreign key for a table using columns with various data types. Unfortunately, SQL Server Migration Assistant (SSMA) fails to convert them to SQL Server correctly since it does not support such elements. As a result, when you try to convert the Oracle code including the foreign key with the columns of different data types, you will see the […]

The pivot clause is an integral part of the Oracle database. In particular, the pivot_clause of the SELECT statement allows you to write crosstabulation queries. Here you can rotate rows into columns and aggregate data in the rotation process. As an important data warehousing element, pivot rotates a table-value expression. To be more specific, it turns the […]

In Oracle, database links are important features that enable you to access objects on another database. SQL Server has a direct alternative to this function. It provides a linked server or an OPENQUERY feature that allows you to emulate the database links’ functionality. Unfortunately, SQL Server Migration Assistant (SSMA) fails to convert these links automatically. […]

Preventing clients from overspending is one of our top priorities. Hence, we pay close attention to the cost of Oracle to SQL server migration in order to provide the most economical solutions while keeping the highest level of quality. Over years, we have served many clients and helped them to keep costs under control. For […]

Oracle databases have many specific functions and features. For example, it stores a period of time with specific interval expressions. This may cause issues during the database migration from Oracle to SQL Server. When you use SQL Server Migration Assistant (SSMA) for converting Oracle with interval expressions, you will observe the O2SS0006 error message. This may happen because that SSMA does not […]

Proprietary database features often create significant obstacles for developers. To demonstrate as an example, we will take a look at one of Oracle’s most valuable proprietary features – Oracle Call Interface (OCI). It ensures efficient communication between the database and the application code. Surely, you may use other options for connecting to Oracle. However, once […]

Defining a naming convention for the conversion of packaged procedures and functions is a very important step during migration of Oracle database to Microsoft SQL Server. Experienced architects usually point out that this step is as significant as setting schema and data type mapping. Naming convention should be defined at the beginning of the migration […]