Using the Backup-Restore Utility
The WFM Backup-Restore Utility (BRU) is included in the WFM Database Utility (DBU) Installation Package (IP). Unlike the old backup file (.MDB format), which had a maximum 2 Gb size limit, the BRU uses a new backup file format (.DB) and has no file size limit.
This backup file format, which is much faster than DBU format, replaces the backup file format used in previous WFM releases. The BRU can backup and restore MSSQL and Oracle databases to the new backup file (.DB) format, and a backup created from one database type can be restored to a different database type.
Incompatibilities in Database Schema
The BRU is designed to mitigate minor incompatibilities in database and file schema that might occur if the backup file was created with an unofficial (not Generally Available) or minor release of the BRU. The BRU attempts to restore to the database to a non-empty database, while retaining (or updating, if needed) the database version. In this case, the existing data is overwritten. However, in some cases the database is successfully restored. For example, a 7.6 database backup could not be restored to an 8.x non-empty database, because the two schema are very different.
If, for some reason, the BRU backup process is cancelled at the mid-way point, the BRU continues from the latest point after the backup process is restarted.
The backups created by BRU are accepted by Genesys Customer Care.
Command Line and Usage
Use the following command line and usage commands syntax:
WFMBRU.exe <command> <data source> -FILE <file name>.db
Table: Usage Commands
|-BACKUP||Backup the WFM database to a backup file.|
|-RESTORE||Restore the WFM database from the backup file (database is created if it does not exist).|
|-UPDATE|| Update the WFM database to the latest schema version (can be combined with -RESTORE).|
Can also be used to create the latest schema on an empty database (the database is created if it does not exist).
Table: Data Source (Connection Strings)
|-DSN <OLE DB connection string>||Enables specification of the OLE DB connection string directly (should not be used with –DB option)|
|-DB <Connection String>|| Specifies the connection in simplified syntax that is later translated into OLE DB connection string format.|
See usage examples in Table: -DB String Format for Various Databases for details.
If both the -DSN and -DB connection strings are specified, the BRU used the -DSN string.
Table: -DB String Format for Various Databases
|MSSQL (Fast Native Client)||"mssql++;<server>;<database>;<user>;<password>"||mssql++;dbhost;dbname;sa;password|
Examples of Usage Command Lines
To back up the database, follow example 1 or 2:
Backup Oracle database:
- WFMBRU.EXE -BACKUP -DB "oracle;<tnsaddressname>;<user>;<password>" -FILE <backup>.db
- WFMBRU.exe -BACKUP -DSN "Provider=OraOLEDB.Oracle;Data Source=<DBMS Name>;User ID=<User Name>;Password=<Password>;" -FILE <backup>.db
Backup MSSQL database:
- WFMBRU.EXE -BACKUP -DB "mssql;<server>;<database>;<user>;<password>" -FILE <backup>.db
- WFMBRU.exe -BACKUP -DSN "Provider=SQLOLEDB;Data Source=<DBMS Name>;Initial Catalog=<Database Name>;User ID=<User Name>;Password=<Password>;" -FILE <backup>.db
Restoring old .MDB Format Backups
BRU can convert old .MDB format backups to the new format by backing up the old backup format into the new one. The Microsoft Access Database Engine 64-bit version must be preinstalled so BRU can locate the provider for conversion.
WFMBRU.exe -BACKUP -DSN "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=<backup>.mdb" -FILE <backup>.db
WFMBRU.exe -BACKUP -DB "access;<backup>.mdb" -FILE <backup>.db