Oracle to PostgreSQL migration tool
Comparing Ora2Pg with АWS SCT for Oracle to PostgreSQL migration
29 Jul 2020 , Bill Ramos

I’m seeing an increasing trend with our customers running Oracle databases wanting to reduce costs by moving to PostgreSQL. The open-source community has made innovations over the years to increase compatibility with Oracle database through with new features and extension libraries to make the migration easier. I felt that by comparing Ora2Pg with AWS SCT, people wanting to migrate Oracle to PostgreSQL for running on AWS would benefit anyone attempting this effort. As a company recognized for our database migration […]

Development project Migration Platform
Development mode, expected results, and advanced backup for DB Best Migration Platform
22 Jul 2020

What’s new in DB Best Migration Platform 1.3? DB Best has released a new version of Migration Platform, a program that automates every stage of database migration. In this version, we introduced a new mode for in-depth database testing — Development Project. This mode introduces extra capabilities for the Test Organizer module by creating Expected Results that can be compared with test results later. We also introduced the Setup & Teardown tab — a place where you can manage datasets […]

Database Compare Suite 5.3 BigQuery
Database Compare Suite 5.3 brings BigQuery support
10 Jul 2020

DB Best has released a new version of Database Compare Suite. This version supports Google’s BigQuery, a serverless and highly scalable cloud data warehouse platform. Read the blog post to learn more about other new product features.

test automation framework
Adding a test automation framework into a database migration CI/CD pipeline

As your solution grows together with the number of users, it becomes more challenging to launch updates timely. A manual tests-driven QA process drags down new deliverables. Now it takes your team days to cope with batch-job testing and weeks for an overall regression cycle. You have to pay more for the QA and hope for your users to be patient while waiting for fixes and updates. Oops, that’s a slippery slope!

In this blog post, we’ll tell how we built a solid test automation sequence running on AWS. This allowed our client for regular deliverables and shortened spending for testing. At the final, the DB Best covered 70% of apps with automated tests and reduced regression time from 5 days to 5 hours.

Using Azure DevOps and PowerShell to automate testing of SSIS packages
28 May 2020

One of our customers aimed to modernize their on-premises project and replace the aging AS/400 system with Microsoft SQL Server. Having an enormous amount of code, the existing program was almost maintainable and cried for a smart solution. DB Best developed a brand-new way to manage epic projects. We required a smart solution to optimize costs and streamline the process. Our team leveraged the latest DevOps practices to create a solution that allows for managing the epic systems in layers. […]

Utilize Machine Learning to double the retail sales
22 Apr 2020

Every retailer knows that product position within their store has a direct influence on revenue. But how do you apply this knowledge? Would you win more by selling a batch of cheaper goods or a few high priced items? Will the product placed on the same position in two different outlets get equal attention from the consumers? DB Best leveraged neural networks and machine learning algorithms to develop a solution that allows for increasing sales and doubling the retailer’s revenue […]

How we improved customer analytics with machine learning algorithms
16 Apr 2020

For retail businesses with distributed point of sales (POS) systems, you can often run into the problem where stores fail to synchronize their data with the centralized data warehouse. If you are not aware of this situation, you can end up taking faulty business decisions when making seasonal adjustments for your supply chain. The top-selling product for the last week at a given store ends up not getting resupplied. Even worse is when last week’s hot seller, no longer is.

In this blog post, we’ll discuss how machine learning anomaly detection for retail POS systems can identify sites that fail to consistently report data into a centralized data warehouse.

Backup Improvements and Errors Handling for DB Best Migration Platform
15 Apr 2020

DB Best has released a new version of Migration Platform, a well-rounded program for automating database migration processes. This newer 1.2 version improves error handling practices for Test Organizer by creating additional mapping rules for matching different error messages and codes. We also added the partial data backup and restore functionality along with the capability to add and remove tables from existing datasets for the Data Store module. On top of that, we enabled command timeouts for several major modules.

Eliminate safety breaches in construction with ML algorithms
10 Apr 2020

In this blog post, we describe how we applied our knowledge in machine learning and computer vision to prevent one of the most common safety breaches among builders. The DB Best team came up with a solution utilizing the YOLO object detection algorithm for a neural network to detect those not wearing hard hats on a construction site. Our algorithms reached 98% accuracy in identifying troublemakers analyzing video materials in real-time!

Database Compare Suite 5.2 brings MariaDB support
07 Apr 2020

DB Best has released a new version of Database Compare Suite. This version supports MariaDB, a popular fork of MySQL database platform. Another major improvement of the latest release is virtual views. Read this blog post to discover how to use these data objects and when you need to create them.