setting up SQL Server on Linux
Greater performance with lower cost with SQL Server on Linux Data Warehouse
26 Aug 2019

What do you do when your data science team needs to perform read-only data warehouse queries against your mission-critical online transaction and batch processing database? One of our customers, a global multimedia company, had exactly this problem with their production AWS deployment of SQL Server 2014 AlwaysOn on EC2 instances. Their data science team was performing read-only queries over 4 terabytes of historical data. These queries are ad-hoc and look at multiple months of historical data for analysis. The queries would consume all available I/O on the production databases environment and impede the performance of the primary workload. Th...

Detailed data comparison
Detailed data comparison with Database Compare Suite
20 Aug 2019

We continue our blog post series that cover the key Database Compare Suite features. In our previous blog post, we talked about validating data migration. We discovered that several tables are different. Now, we want to see the exact data differences. Check out our video to see how simple this is with detailed data comparison operation in Database Compare Suite. As you can see, Database Compare Suite allows for identifying data differences in 2 tables. Using the detailed data comparison operation, you can discover the exact data differences row by row. Also, you can easily navigate through the different data values. This helps figure out how ...

Convert Oracle sequences
Converting Oracle sequences to Microsoft SQL Server
15 Aug 2019

In Oracle, you can use a combination of a trigger and sequence to generate unique values for the key columns. However, when migrating your Oracle database to Microsoft SQL Server, you need to find the right path to convert this construction. This is an architecture-level decision, so you need to approach it at the very beginning of your migration project. Otherwise, you will need to recreate tables, reload data and recreate backups, and even rewrite code that relates to these tables. Original Oracle code Let us consider the following example. The source Oracle script looks as follows: 12345678910CREATE OR REPLACE TRIGGER TEST.TR_TEST BEFORE I...

Data comparison
Comparing data in your databases using Database Compare Suite
13 Aug 2019

At DB Best, we believe our Database Compare Suite is the ultimate solution for database developers, administrators, quality assurance, and DevOps engineers to simplify their daily routine. It allows you to compare schema and/or data with source and targets on either the same or different database engines. Until we have Database Compare Suite on every developer’s desktop, we are starting a series of mini-blog posts with short videos to hopefully convince you that you can’t live without our Database Compare Suite! Let’s kick things off with a scenario where we just migrated an Oracle database to PostgreSQL using AWS Database M...

Oracle Forms SQL statements
How to run SQL statements after migrating from Oracle Forms to web applications
09 Aug 2019

At DB Best, we’ve helped several customers move away from Oracle Forms to a modern web-based solution. To accomplish this, developed a totally new Oracle Forms Converter. This tool allows for automating the migration of your Oracle Forms to web single page applications.  In this blog post, I’ll talk about making SQL statements from Oracle Forms compatible with your new application. The problem Oracle Forms run different queries and execute SQL statements directly at the connected Oracle Database. These SQL statements are embedded into your Oracle Forms. When you migrate Oracle Forms to the web application, you need to take note...

DevOps and test automation: Docker saves the day!
06 Aug 2019

Recently, the DB Best team migrated a customer’s database from Apache Cassandra to Amazon DynamoDB. As part of this project, we needed to run multiple tests to ensure perfect quality for our delivery. However, we faced a problem in setting up the test environment. Even though we were using AWS CloudFormation templates for the EC2 instances, it was taking over 30 mins to get the dev/test environment setup. In addition, our developers couldn’t run parallel regression testing. So, we decided to leverage Docker to automate the environment set up. In this blog post, we will share our experience with using Docker for automating a NoSQL data...

ongoing development
Why you should never stop application development?
02 Aug 2019

The application development lifecycle has 6 proven stages that lead to the application’s release. In reality, the development process never ends with the initial release. There are always brighter ideas, new features, and enhancements that take you back into the development phase. Later, these ideas become the 2.0 version of your application. That’s what we call the “ongoing development process”. Get better with each release None of the market leaders such as Facebook, Instagram, Airbnb or Uber started with the functionality they have today. The initial version these giants released had almost nothing in common with the design and fu...