Indigo DQM Backup supports multiple Data Sources and Types including Microsoft SQL Server, Microsoft Access, ODBC, OLEDB, MySQL, Oracle, Postgre, Firebird, XML, JSon and CSV. Data Sources can be securely Backed Up and Restored using the Indigo DQM Backup Utility.
Select the Data Source Tab from the Indigo DQM Data Management Studio and right click on the Data Source and select Restore or choose the Restore Utility from the Tools menu.
Click Calculate Sizes to work out the Data Size for each Backup Item.
Select the Item(s) to Restore from the list. Enter a Name for the Backup Package and the location to Backup the Data. Click Execute to start the Restore process.
Once the Restore operation has completed information about the Restore process will be displayed in the Log.
It is recommended for efficiency and compactness that all Backups are compressed. For security all Backup Packages should be Encrypted.
To view Advanced Properties for the Backup Package click the Properties button on the Toolbar.
If the Backup Package is Compressed the Location to Restore the Data Files used for the Restore Operation can be setup to be either a Temporary Folder or a Custom Folder. By using a Custom Folder to Restore Compressed Data Files you can specify an option to keep the Data Files after the Restore Operation completes.
Encryption Passwords are used to create Strong Encryption Keys for the AES 256 System. 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.
Restore Data from the Internet / Cloud
Backup Packages can be uploaded to the Internet for storage on the Cloud. To Restore a Backup from the Internet click the Properties button for the Backup Location.
The URI properties of the Data Source allow the parameters to be defined for Host, User Name and Password if required.
Enter the Host, Port and Path for the Data and the Security Credentials.
Data Schema's and Auto Number / Increment
Databases often use the Auto Number / Increment as the ID Column on a Data Table. This practice is not recommended and for the Data Restore operation to work correctly the Auto Number must be Disabled.
If other Data Tables are linked via this ID Column the relationships between the Tables maybe lost if the Auto Number feature is Enabled because the Database will ignore the number in the Restore Data and just Auto Increment the ID automatically. For a successful Data Restore Auto Number / Increment must be Disabled or redesign your 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 Encryption. To Encrypt a Backup Package check the Encrypted option.
Encryption Passwords are used to create Strong Encryption Keys for the AES 256 System.
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 System (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.