To solve a completely offline SD application scenario, it is useful to have the possibility of backing-up and then restoring the application's local database.
It is an external object defined in the GeneXus Core module
This method performs a backup of the local database and all its resources including:
- the .sqlite file
- all binary files referenced from the database (blobs, images, etc.)
- the synchronization hashes
- the database's MD5 hash value.
Syntax
&Result = DataBase.Backup(&Path)
Where:
- &Result is based on the ResultCode domain (see below)
- &Path is a String variable with the URI of the backup file
Example
&path = Directory.ExternalFilesPath + "/backups/DB15012020.zip"
&result = Database.Backup(&path)
Performs a restore of a previously created backup.
It leaves the database operational so that the user can keep using the application after the restoration.
Syntax
&Result = DataBase.Restore(&Path)
Where:
- &Result is based on the ResultCode domain (see below)
- &Path is a String variable with the URI of the backup file
Example
&path = Directory.ExternalFilesPath + "/backups/DB15012020.zip"
&result = Database.Restore(&path)
The domain used to return the operation result.
Valid values are:
| Code |
Message |
| 0 |
Success |
| 1 |
Application is not offline |
| 2 |
Path is not correct / Backup file not found |
| 3 |
Database structure does not match |
| 9 |
Internal error |
The backup and restore operation should not be performed while there are other operations accessing or modifying the database. The behavior in those cases is undefined and will probably create some inconsistencies.
The backup and restore operations should be used with care if the application also has synchronization. Since the records added or deleted by the restore operation are not sent to the server, there could be cases where information is lost. Also when restoring a backup, the synchronization hashes restored on the device may no longer exist in the server (depending on the Minimum Time Between Table Purges property), which may be a problem when the device tries to synchronize again.