Andrei Ivanov

Technical Wordsmith

15
Years of experience
72
Blog posts
Always
Happy readers
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 virtual column doesn’t converts to the target database. This will result in an error when you will try...

Database Compare Suite update 4.9
Database Compare Suite update 4.9 brings Azure Synapse Analytics 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 Synapse Analytics along with some other improvements. Covering 12 Major Database Platforms With the support of Microsoft Azure Synapse Analytics (previously 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. The full list of supported database dialects includes Amazon Redshift, Azure SQL Database, Azure Sy...

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. (more…)...

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. (more…)...

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. We can integrate any of these proven solutions to build the mobile app according to your business needs. Let’s take a look at the technologies we needed to power this application. (more…...

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, Amazon released version 1.0.602 of AWS Schema Conversion Tool (SCT). With the help of data extraction agents that were introduced in this update, AWS Schema Conversion Tool now...

Building an Ultimate Cloud-based Business Intelligence Solution for Agriculture
05 Jun 2017

One of the largest North American agricultural enterprises has been envisioning and designing a new cloud-based Business Intelligence and Data Warehousing architecture. They were using a fragmented system, based on Oracle database, while the reports were presented as a mix of SQL Server Reporting Services (SSRS) and Excel dashboards. We came up with a solution that allowed to consolidate all reports with Power BI dashboards. In addition, we proposed to migrate the original database to Azure Synapse Analytics (previously Azure SQL Data Warehouse). This helps reduce license costs and improve the performance of the newly created cloud database s...

Moving Oracle Forms to Web-Based User Interface
Moving Oracle Forms to The Web as a Part of Database Migration Project
16 May 2017

A government healthcare organization wanted to move their Oracle Forms to a modern web-based UI. We offered to migrate their source Oracle database to SQL Server while converting the deprecated Oracle Forms to the modern-looking web-interface. We used a previously developed technology to automate the major part of Oracle Forms conversion. To demonstrate the feasibility of this technology, we converted one the most complex forms. Having successfully completed the proof of concept, we convinced the customer to continue our partnership. Learn how we approached this database migration project from the following video. (more…)...

Developing mobile applications to shape the brighter future
12 May 2017

Staying on the cutting edge of modern technologies, DB Best application development team constantly strive to offer the best solutions for our customers. Simply watch the following video to see the examples of some cool features we can add to your business app be it a cinema house, a shopping mall or any other place, crowded with people. Let’s take a look at the impressive list of technologies that made the creation of this mobile application possible. (more…)...

Database Compare Suite update 4.8 brings Netezza support
03 May 2017

We’re excited to bring you the latest release of Database Compare Suite. The new version 4.8 brings support for IBM Netezza versions 7.2.1 and higher along with some other improvements. Covering All Major Database Platforms With the support of IBM Netezza, the total count of available database platforms in the Database Compare Suite reached the amazing total of 11. You can see the full list of supported database dialects on the image below. They include Amazon Redshift, Azure SQL Database, Greenplum, IBM DB2, IBM Netezza, Microsoft SQL Server, MySQL, Oracle, PostgreSQL, Sybase ASE and Teradata. This means that you can use 55 heterogeneous a...