Learn more about

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

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. The problem Oracle database server includes an Oracle database and an Oracle instance. You may learn more about the architecture of the Oracle server here. […]

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