Page Comparison

...

• If you want to use static on demand backups with Oracle or SQL Server, we recommend running Datical DB versions 5.6 or higher.  
• If you want to use static on demand backups with Postgres, we recommend running Datical DB versions 6.12 or higher.
• Note that if you use backup on_demand, you will NOT get the full benefits of using the schemaName property in the metadata.properties file:
  • If you are using backup mode "always", then the schemaName property will limit the schema list to the relevant schemas for three aspects of packager: backup, restore, and snapshot. 
  • However, if you are using backup mode "on demand" then the schemaName property will limit the schema list to the relevant schemas for only one aspect of packager: snapshot.   When you set backup to "on_demand" all of the schemas in the project will be backed up and restored, the schemas for backup/restore will NOT be limited based on the schemaName property.
• Troubleshooting performance time of on_demand static backups:  If you are implementing static/on_demand backups but have not seen a significant improvement in how long your packager jobs take to run, check your configuration.  If you have set databaseBackupMode=on_demand but are still using createDatabaseBackup=true in your main packager jobs that process scripts, that is an unusual configuration.  Packager will work with that configuration but it will still create a new backup file for each packager job that processes scripts, and therefore you would NOT be getting the possible performance benefit that you would have in the more typical configuration of creating a nightly backup separately and re-using that backup file when processing scripts (to avoid running backup each time).  To optimize the on_demand backup, do NOT use createDatabaseBackup=true with your main packaging job that processes scripts (assuming that the backup file was already created and is in place). 

4.  For Oracle, you can set the "parallel" property in the deployPackager.properties file for Oracle backup/restore as described in these pages:

...