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 the previously developed internal tool to automate the Oracle Forms conversion process, but […]

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.

Change Data Capture for SQL Server Table Replication
Using Change Data Capture for SQL Server Table Replication
06 Apr 2017

A major bank in Europe that we’ve been working with over the years requested our help in upgrading SQL Server 2008 to 2016. Since we performed the migration process originally from DB2 to SQL Server we had a deep knowledge of the customer’s data. Because of the need to have a highly available system and they could not afford to be down. Our client needed a way to downgrade to the old database system in case something bad happens to the upgraded system. […]

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

Our customer reduced costs by over 20% by optimizing Azure elastic pools
29 Mar 2017

A leading provider of payroll and HR services in the United States faced the difficulties with configuring the Azure elastic pools for the needs of their SaaS Azure app. The Azure tools provided by Microsoft were not flexible enough to fine-tune the performance of 20,000 customer databases with different utilization patterns. Moreover, it was almost impossible to maintain so many databases manually. We came up with the solution that allows automatic management of the customer databases basing on extensive monitoring of elastic […]

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

Using AWS Schema Conversion Tool Extension Pack for OLTP databases
23 Mar 2017

Running your database migration projects, you may have already noticed that AWS Schema Conversion Tool (SCT) automatically generates an additional schema called extension pack. This schema emulates the system functions and specific features of the source database in your target DB instance. In the following video, we demonstrate how to apply this extension pack to the OLTP database. And in our future blog posts we will talk about working with extension pack for data warehouses. Make sure to check out our […]

Moving workloads to the cloud: MongoDB Cluster Deployment Automation
21 Mar 2017

An international healthcare company felt the urge to migrate core components of their application initially to Azure Infrastructure-as-a-Service (IaaS) with a long-term goal of transferring the solution to Azure Platform-as-a-Service (PaaS). We came up with a solution that automates the ‘lift and shift’ migration of their existing Linux-based MongoDB Cluster (dozens of virtual machines) to Azure IaaS. We created the cloud automation script that allows not only to deploy  the customer’s system but also to upgrade and scale it in […]