Blog: Development mode, expected results, and advanced backup for DB Best Migration Platform

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 by saving and restoring them after the text execution. This is a nice addition to the default means of Data Store functionality for keeping data in a safe spot.

The list of updates includes:

Development Project

Please welcome our new project mode. The Development Project is a new mode designed for testing a single database with extra tools in your toolbelt. It works as an environment for mimicking real databases and setting up performance goals that will later be implemented in a production environment. It addresses the customers’ needs for a separate environment for modifying core database functionality, measuring its effectiveness, and applying changes without risk to the production database.

For the Development Project mode, Test Organizer receives the means for checking return values, parameters, and affected objects for expected results using the Expected Results feature. These results are then matched with Test Results to show their differences. The feature shows how both schema and data elements behave in different environments — expected results show how database elements are supposed to function, while the test results show database elements in a close-to-production state. Made for both manual and automatic tests, expected results can be applied during a test creation or after a whole category or group are added to Test Suite.

Creating expected results in Development Project

The Expected Results tab is available as the last stage of the New Test creation. First, users need to choose a template. Then, select affected data objects by pressing the Refresh button and pressing the Generate button to create a list of affected objects. Then, review the expected results by clicking on them and press Save.

Expected result stage

Figure 1. Generated expected results

Once the test is complete in the Test Suite window, users can review which information matched the expected results. To accomplish this, we have added settings in Advanced Compare Settings > Override Parent Options > Equal rows 

If a test was created without specifying expected results, it will have a yellow circle. By hovering over the test, it will display a text message saying that it’s Missing expected results. If a certain object misses expected results, the parent folder will also be marked with a yellow circle.

Expected results for auto-generated tests

For auto-generated tests, users can set up expected results after their creation. By heading to Test Organizer > Auto-generation Settings > Programmability Object Settings, users can check for Strategies for tests auto-generation.

Auto-generation for expected results can be processed for different database objects: schemas, categories, or groups. Once the test is completed, users can inspect each element in the Results tab to see how they match the expected results.

Setup & Teardown

Another new feature is the introduction of Setup & Teardown functionality for the Test Organizer module. Users now have an opportunity to create quick backups that can be adjusted to the project’s needs.

The Save pre-test database option allows for creating a certain state and configuration of a database that will be restored after the test is over. This state can be different from a Golden Copy. Users can select this option by clicking on a plate or by checking a corresponding field in the Backup and Restore menu. The whole process is automatic, and it only requires users to specify a schema as a backup location.

The Restore test initial dataset option is similar to the standard Golden Copy functionality. It relies on a previously created and backed up dataset — it could be an existing dataset or a newly created one in the Data Store module. To use an existing dataset backup, users need to specify its name from a drop-down menu. Note that both options are available and can work independently throughout the testing process.

Extra backup

Figure 2. Setup & Teardown setup

Free trial download

You can download a free trial version of the DB Best Migration Platform from the official product page. This version works for a limited period. However, if you want to continue using this fully automated database migration product, please drop us a line.

Share this...
Share on Facebook
Tweet about this on Twitter
Share on LinkedIn