AWS Schema Conversion Tool
Oracle to PostgreSQL migration with AWS SCT: How to convert INSERT ALL statement
19 Jun 2017

In Oracle you may use the conditional insert clauses, for example, an INSERT ALL statement to add multiple rows with a single command. You can insert rows into one table or even multiple tables using just one SQL statement in Oracle. However, PostgreSQL doesn’t support such statements that attempt to inserting multiple rows. So, when you try to convert the source Oracle code that includes the INSERT ALL statement to PostgreSQL in the AWS Schema Conversion Tool, it will generate the following […]

Oracle to Azure SQL Database shift may save up to $1 million
16 Jun 2017

‘Low-performing and costly’ — these were major characteristics of the Oracle system of one of our customers, a leading US automotive corporations. In this regard, it was quite natural for them to consider migrating to another database platform. We suggested changing their Oracle Database to Azure SQL Database and moving their applications to Azure services. However, the customer may well anticipate this Oracle to Azure migration solution. Why? Because according to the calculations made by our experts, they can save […]

Oracle to PostgreSQL database migration and unification project
Using PostgreSQL in cloud alongside with Oracle to enhance the database system performance
15 Jun 2017

One of the leading independent software vendors in educational domain needed to expand their original Oracle database system. They wanted to add a new PostgreSQL database running on AWS RDS to their original system and upgrade the connected Java application to support both database platforms. We came up with a proof of concept and converted one of the largest customer’s database schemas to PostgreSQL, demonstrating how the upgraded system might work. To do so, we updated the application by adding […]

Oracle to SQL Server migration with SSMA: How to convert virtual columns
14 Jun 2017

Oracle allows you to specify virtual columns in the table definition. Oracle doesn’t store the data in virtual columns on the disk. On the contrary, the database derives the values in a virtual column on demand by computing a set of expressions or functions. The computed columns in SQL Server are considered as a direct analog of Oracle’s virtual columns. The problem is that the SQL Server Migration Assistant (SSMA) for Oracle converts the virtual columns as a DEFAULT expression. Thus the logic that stands behind the […]

Database Compare Suite update 4.9
Database Compare Suite update 4.9 brings Azure SQL Data Warehouse support
14 Jun 2017

We’re excited to bring you the latest release of Database Compare Suite. The new version 4.9 features support for Microsoft Azure SQL Data Warehouse along with some other improvements. Covering 12 Major Database Platforms With the support of Microsoft Azure SQL Data Warehouse, the total count of available database platforms in the Database Compare Suite reached the total of 12. This dozen includes 5 specific data warehouse platforms. So, you can keep humongous data under control with Database Compare Suite. […]

Oracle to SQL Server migration with SSMA: How to convert unsupported SQL clause
13 Jun 2017

Oracle allows you to assign a non-scalar condition in WHERE clause. The problem is that SQL Server doesn’t support conditions of this type. Thus, the SQL Server Migration Assistant (SSMA) for Oracle doesn’t convert queries with a a non-scalar condition in WHERE clause. So, when you try to convert the source code that includes a non-scalar condition in a WHERE clause, SSMA will generate an error O2SS0001.

Taking advantage of Always On Availability Groups while upgrading your SQL Server
12 Jun 2017

One of the largest US national credit unions needed to upgrade their obsolete SQL Server database to take advantage of the latest Always On Availability Groups offerings. We came up with a database upgrade solution that included re-architecting of the customer’s applications. In the end, our customer started using a truly high availability database system while improving its failover features. Learn more about the technical issues of this upgrade project from the following video.

Stepping up the car rental mobile application user experience
09 Jun 2017

You can shape a better future by implementing some of the greatest features in your app. Here’s a stunning example of how you can put it into practice. Recently we’ve built an ultimate car rental mobile application as a proof of concept. Now we want to share the best practices and ideas we’ve implemented in this app with you. Watch the following video to learn more about the approach we can use to develop a similar amazing application for you. […]

Comprehensive Java app upgrade while migrating to SQL Server
Comprehensive Java app upgrade while migrating to SQL Server
08 Jun 2017

One of the largest transportation companies in the United States needed to migrate their Oracle-based application to SQL Server platform. The customer’s application code had high query complexity which increased the level of difficulty for our automated tools. In order to overcome this challenge, we performed manual conversion of the embedded SQL code along with application upgrade to the latest Java version. The customer didn’t have the time, resources or expertise to modernize and migrate their many hundreds of business critical […]

Using data extraction agents to fulfill the database migration projects in AWS Schema Conversion Tool
07 Jun 2017

The Amazon Database Migration Service (DMS) does a great job in helping to copy data from your on-premises databases to AWS RDS for OLTP workloads. When you start talking about terabytes of data, the prior version of DMS was not up for the job. Amazon realized the shortcoming and developed an extension to the Schema Conversion Tool to create a performant way to migrate Terabytes of data from your on-premises Data Warehouse platforms to Amazon Redshift. On May 11, 2017, […]