Indigo DQM Backup supports data from multiple different sources and types including Microsoft SQL Server, Microsoft Access, ODBC, OLEDB, MySQL, Oracle, Postgre, Firebird, XML, JSon and CSV.
The Backup Utility can securely backup data defined in the Indigo DQM Data Management Studio.
Select the Data Sources tab and right click on the Data Source and click Backup or choose the menu Data | Backup Source.
Click 'Calculate Sizes' button to work out the data sizes in byte(s).
Select the item(s) from the list for the Data Backup. Enter the details for the Backup Package and the location to Backup Package. Click the 'Execute' button to start the Backup process.
Once the Backup operation has completed information about the process will be displayed in the Backup Log.
It is recommended for efficiency and compactness that all Backup Packages are compressed and for security they should be encrypted.
Backup Properties
Advanced properties for the Backup Package allow additional configuration options to setup.
If the Backup Package is compressed the location to the data files used for the restore operation can be setup to be either a 'Temporary Folder' or a 'Custom Folder'.
By using custom folders for the restore any compressed data files can specify an option to keep the data files after the restore completes.
Encryption passwords are used to create strong encryption keys for the AES 256 Advanced Encryption Standard. Strong passwords must be used to ensure strong encryption keys are generated. Passwords are recommended at least 16 characters long with a mixture of upper and lower case letters, numbers and punctuation.
Backup to the Internet / Cloud
Backup Packages can be uploaded to the Internet for storage on the Cloud. Properties of the Data Source allow the parameters to be defined for URI location.
Enter the host, port and path for the URI location of the backup and the security credentials if required.
Click OK to update the Backup Package URI.
Data Schema's and Auto Number / Increment
Databases often use the Auto Number / Increment as the ID Column on a Data Table. For the Data Restore operation to work correctly the Auto Number must be disabled.
Relationships between Data Tables that are linked via this Data Column maybe lost if the auto numbering feature is enabled because the Database will ignore the number in this Data Column in the Data Restore operation.
For a successful Data Restore the Auto Number / Increment must be disabled or redesign your Data Schema without the auto numbering feature.
The Backup Utility does not Backup Data Schema, Structure or any Stored Procedures.
Data Security and Encryption
Data Backups can be encrypted and stored securely using AES 256 Advanced Encryption Standard. To encrypt a Backup Package check the encrypted option.
Encryption passwords are used to create strong encryption keys for the AES 256 Advanced Encryption Standard.
A secure password must be setup in the 'Program Settings and Options' or applied to an individual Data Asset Store. By default a global encryption password will be used but it is recommenced that you create your own unique password.
Encryption passwords must match when encrypting / decrypting Data. It is recommended that a copy of your password be stored in a secure location. If you lose the password it will be impossible to decrypt any encrypted Data.
The Advanced Encryption Standard (AES) 256 is a symmetrical encryption algorithm that uses a 256-bit encryption key. It is accepted by the U.S. and Canadian governments as the most secure way to store sensitive Data.
With AES-256 bit encryption you can be assured that you will be the only one who can access your critical information.
