Backup and Restore of metadata automatically

Backup and restore of Delphix Engine metadata can be done automatically using scripts-

1. backup_dlpx_metadata.sh
2. restore_dlpx_metadata.sh

Metadata Backup

Script: backup_dlpx_metadata.sh

Execution: ./backup_dlpx_metadata.sh engineName

Each Execution of script will create backup directory in below format – -metadata-backup--

The automated backup process is ordered in the below sequence-

1. Create backup directory in format, -metadata-backup--
2. Create sys_config directory in backup directory, and export system configuration in required files.
3. Create users directory in the backup directory, and export the user info in the required files.
4. Create policies directory in the backup directory and export the policies info in required files.
5. Create config_templates directory in the backup directory and export the vdb configuration templates info in the required files.
6. Create hook_templates directory in the backup directory and export the hook operation templates info in the required files.
7. Create environments directory in the backup directory and export the environments templates info in required files.
8. Create db_objects directory in the backup directory and export the database objects (dSources/VDBs) info in the required files.
9. Create ss_objects directory in the backup directory and export the self-service objects (templates/containers) info in required files.

Metadata Restore

Script: restore_dlpx_metadata.sh

Execution: ./restore_dlpx_metadata.sh engineName backupDirectoryName

Execution of script will read the data present under the provided backup directory, perform manipulation on backed up data like updating passwords by reading csv files to make it ready for restore, and then restore the metadata.

The restore process is ordered in the below sequence-

1. Read backup directory passed to restore script.
2. Read users directory in the backup directory and create the users on the Delphix Engine.
3. Read environments directory in the backup directory and create the environments.
4. Read db_objects directory in the backup directory and create the dsources.
5. Read config_templates directory in the backup directory and create the vdb configuration templates.
6. Read hook_templates directory in the backup directory and create the hook operation templates.
7. Read db_objects directory in the backup directory and create the virtual database.
8. Read policies directory in backup directory and create, assign and update policies.
9. Read ss_objects directory in the backup directory and create the self-service objects, templates, and containers.

Detailed documentation about automated backup and restore process is available HERE