More with tags:

#database-migration

#aws-sct

#aws

#Оracle

#PostgreSQL

#aws-dms

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

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

PerdidoOnline, a Puerto Rico based startup came up with an idea to help the unfortunate among us who lose our belongings wherever we go. Our client wanted to develop a locator and tracking solution t that will substitute the lost and found offices all over the world and save the users from worrying about losing their property. Read more to learn how our team turned this idea into reality.

Speed is everything in the highly competitive domain of e-commerce. Digital marketplaces of varied sizes appear at an ever-increasing rate and it becomes more challenging to stand out among the competition. According to estimates, a 6-months delay in a software product release can cut its profitability by at least 30%. These numbers had been relevant 30 years ago, and they have become even more relevant in the modern time or rapid digitization. That’s why entrepreneurs with a promising digital marketplace […]

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

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

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

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

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 which the Oracle materialized view includes FLOAT columns, subqueries, GROUP BY or WHERE clauses, MINUS, INTERSECT, UNION, etc. By default, SQL Server Migration Assistant (SSMA) converts Oracle […]

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 presents our recommendations on how it should be approached and fixed. Related posts Here is the list of blog posts on the most common SSMA […]

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, such as the constant value term. Interval literals can be specified in terms of seconds, minutes, hours, days, months, or even years. There are two […]

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 because  SQL Server Migration Assistant (SSMA) cannot convert Oracle table functions. Instead, it generates a set of the following errors: O2SS0474: Conversion of the user-defined type […]

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 following message: «Error O2SS0231: Foreign keys with different types of columns and referenced columns cannot be converted». Read this blog post to find out how […]

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 unique value from one expression column into multiple output columns. Besides, pivot performs aggregations where they are needed on any of the remaining column values […]

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. When you try converting a database link query that refers to remote objects, you get the following error: “O2SS0563: Conversion of database link … is not […]