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 […]
Talks on Managing Data and Applications Anywhere
‘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 […]
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 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 […]
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 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.
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.
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. […]
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 […]
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, […]