The DataVirtuality configuration database holds all important data about your system, such as your data model, data sources, jobs and users. In order to be able to restore your configuration as part of a disaster recovery you should frequently backup your DataVirtuality installation.
What can be backed up?
You can backup your data source definitions, virtual schemas, optimizations, job definitions, users and roles and their permissions.
In order to backup your DataVirtuality configuration manually via the Studio, use the File/Export menu item. In the following dialog, choose the items to export.
Your configuration will be exported as SQL. Choose save to file.
As part of an automated backup you can also generate exports programmatically. Navigate to the folder /opt/datavirtuality/dvserver/bin/cli-export-1.0/ and execute the file export.sh on Linux or export.bat on Windows:
./export.sh --host localhost --username admin --password admin --file /home/user/backups/export-`date "+%Y%m%d-%H%M%S"`.sql
This will create dump the configuration into an SQL file at the specified path. We recommend storing your backups on a different server, a network drive or S3 bucket to not loose them in case your server hosting the DataVirtuality instance gets corrupted.
Restoring your configuration
Open a new SQL tab in the DataVirtuality Studio by pressing the SQL button. Paste the contents of the exported configuration into the tab.
It is very important to review the configuration before you run the script.
Execute the SQL. Refresh the items you restored in the DataVirtuality Studio.