Optimizing database expenses by migrating from Oracle to SQL Server
Quick and easy automatic approach to database conversion
12 May 2017

One of the largest US educational organizations has been running their data handling system in Oracle environment. They wished to reduce maintenance costs due to expensive Oracle licensing model, which includes an additional fee for the partitioning feature. We provided the solution of migrating the customer’s database to SQL Server. Reconstruction of the original partitioning system in SQL Server allowed us to save extra money in addition to significantly lower SQL Server maintenance cost compared to Oracle. Check how we performed the […]

Oracle to SQL Server using SSIS
Remote migration from Oracle to SQL Server using SSIS
04 May 2017

A global financial software provider contacted us to migrate their billing solution from Oracle to SQL Server using SSIS for one of their strategic clients located at the other end of the world. They also needed to transfer data from Oracle to SQL Server using SSIS. The actual migration had to be performed by the remote team. In order to do so, our customer was looking for an automated solution with detailed step by step instructions. To meet the customer’s […]

How to revive deprecated Oracle Reports
24 Apr 2017

A large European company decided to migrate their Oracle database system to SQL Server. Of course, they wanted to outmaneuver the performance of their original system. The original customer’s system included a huge bunch of over 700 reports, built in deprecated Oracle forms technology. We offered a solution on the new SQL Server Reporting Services platform. This solution satisfied the rigid performance demands of the customer. We used some previously developed tools to automate the Oracle Forms conversion process, but after […]

Oracle to SQL Server migration with SSMA
Oracle to SQL Server migration with SSMA: How to convert aggregate functions referring to remote table
21 Apr 2017

Oracle allows you to create a query with aggregate functions referring to a remote table. For example, if your query includes two tables: one from the local schema and another from the remote database. You can simply use a database link in Oracle to create that construction. Previously, we already talked about converting database links using a linked server. But the problem is that SQL Server Migration Assistant (SSMA) for Oracle doesn’t convert queries that refer to the remote objects through the database link. So, when you try […]

Oracle to SQL Server migration with SSMA: How to convert database links
13 Apr 2017

Oracle uses database links to access objects on another database. In SQL Server you can use linked server or an OPENQUERY function to emulate that functionality. The problem is that SQL Server Migration Assistant (SSMA) for Oracle doesn’t automatically convert database links. Instead, when you try to convert a query that refers to the remote objects through the database link, SSMA will generate an error O2SS0083.

Oracle to SQL Server migration with SSMA: How to convert interval literals
30 Mar 2017

In Oracle, you may use specific interval literals that indicate a certain period of time. SQL Server does not have a direct analog for interval literals. Thus, when trying to convert interval literals using  SQL Server Migration Assistant (SSMA) for Oracle, you will get an error O2SS0086. The term literal refers to a fixed data value just as the constant value term. You can specify interval literals in terms of years and months or in terms of days, hours, minutes, and seconds. Oracle Database supports two […]

Oracle to SQL Server migration with SSMA: How to convert interval expressions
30 Mar 2017

Oracle uses specific interval expressions to store a period of time. SQL Server does not have a direct analog for this data type. Thus, when you try to convert interval expressions using  SQL Server Migration Assistant (SSMA) for Oracle, you will get an error O2SS0006. Your source Oracle code may include 2 kinds of intervals: INTERVAL YEAR TO MONTH and INTERVAL DAY TO SECOND. The first one stores the difference in years and months, while the second type stores the difference in days, hours, minutes […]

Oracle to SQL Server migration with SSMA: How to convert materialized view with float type
24 Mar 2017

SQL Server has several different ways of implementing the same behavior as an Oracle materialized view. SSMA cannot understand the original optimization reason for why the application needed the materialized view, so SSMA flags certain conditions as an error. This blog post discusses error O2SS0522 where the Oracle materialized view includes FLOAT columns, WHERE or GROUP BY clauses, subqueries, UNION, MINUS, INTERSECT, etc. Currently SQL Server Migration Assistant (SSMA) for Oracle converts materialized views to SQL Server indexed views. While converting […]

Migrating Oracle database to SQL Server for a leading US healthcare company
Migrating Oracle database to SQL Server for a leading US healthcare company
17 Mar 2017

One of the leading US healthcare organizations needed to upgrade their health record system in an effort to drive down costs while enabling new capabilities. We proposed to migrate the Oracle database to SQL Server to build a scalable and secure architecture. We faced a number of Oracle to SQL Server migration challenges, including the huge volume of data along with very large tables aggregated in the original database. As a result, the customer got the modern, secure, platform while saving […]

Oracle to MySQL migration with AWS SCT: How to convert BULK COLLECT clause
16 Mar 2017

Oracle’s SELECT INTO statement with BULK COLLECT clause allows you to retrieve an entire result set and store it in a PL/SQL collection type variable in a single operation. This approach allows to avoid the use of a loop statement to retrieve one result row at a time, thus making the code compact and effective. MySQL doesn’t support the BULK COLLECT INTO operation, so, SCT can not convert the source Oracle code correctly. When you try to convert the source […]