We continue covering the core features of the DB Best Migration Platform. In this blog post, we will talk about the Data Store module that allows for creating and using database snapshots.
The DB Best Migration Platform creates snapshots of all data or selected tables. We consider the database snapshot as a golden copy of the source data. The DB Best Migration Platform then uses this golden copy to restore data when you need it.
Why do you need a golden copy?
A database migration or upgrade project includes many steps where your data changes significantly. These steps include:
- Database schema changes
- Data migration
- Tests execution
Before each of these steps, you need to create a golden copy. You can later use these copies as a baseline and restore data when needed. One of the best practices is to create an integral copy at the start of the project as a golden copy of your initial data is a must-have.
The Data Store module of the DB Best Migration Platform allows for creating and managing this golden copy. Particularly, you can specify the tables you want to include in the golden copy or restore. You can use the DB Best Migration Platform to create a golden copy for the following database platforms:
- Microsoft SQL Server
- Oracle Database
Daily database development tasks, production processes, as well as the test procedures and functions, may affect your data. You cannot track all the changes and roll back these transactions. So, you need to roll back to the golden copy of your database. That’s what the Data Store module in our Migration Platform is all about. Watch the following video to learn more about the features of the Data Store module.
Lessons learned about the Data Store module
The DB Bet Migration Platform creates separate backups for the source and target databases. We suggest running these processes simultaneously to decrease the time required to generate two golden copies.
The Data Store uses temporary tables in your database to store data. You need to drop these tables after completing the project. You can do this directly in the Migration Platform settings (see the screenshot below) with no manual effort required.
The Data Store doesn’t support tables with user-defined types, virtual columns, and CLOB or BLOB columns. In this case, you will need to create a workaround to backup and restore data manually. You will get a warning message with a list of tables, which were not added to the golden copy.
Backup and restore tables that you really need
Deep integration with Test Organizer is one of the unique features of the Data Store module. The DB Best Migration Platform analyzes your test scripts and discovers the list of affected tables. Data in these tables will definitely change after you run the tests, so, you need to restore these tables from the golden copy. The Data Store module automates the data restore process.
You can automate the data restores and even schedule them in the right order when executing a number of tests.
Also, the Data Store module helps compare your current data with the golden copy. This helps determine the tables you need to restore. However, you can specify the tables to restore manually.