DBCubes

When we create software applications that interact with databases the development phase implies that the database DDL/DML changes should be transferred from DEV machines to QA/UAT/PROD machines. This demo propose a simplified method using essentially a backup restore method: instead of developing a version using the same DB as previous, software development team should create a database to isolate all modifications in this new database. With *.sql scripts for this task might generate issues: because of relationships between object , if we change the order of execution for *.sql scripts this might break this process. In this case of database deployments, we introduce the idea of DBCube/DBCubes. A DBCube it is a separate database having those type of objects that might be modified /updated except tables used for storage of customer data. In this scenario the simplified method to deploy is using a simple backup restore action of DBCube.

CI/CD, Deploy BACKUP, RESTORE