This section only applies to Standard Workgroup Databases, not when using Oracle or SQL Server.
In a Standard Workgroup Database all the version history of a version controlled network is stored in a .wdb file with a file name of the form “sXXX-Y.wdb”. Here XXX is a three digit number which identifies the network type and Y is the object id as shown in the Workgroup Client User interface (via the Object properties page or tooltip). Useful values for XXX in this context are as follows:
- 134 – InfoNet Collection Networks
- 135 – InfoNet Distribution Networks
- 169 – ICM Model Networks
- 190 – SWWM Live Model Networks
- 205 – InfoNet Asset Networks
If you have a large network and make many changes to it, for example via InfoNet Mobile, this .wdb file can get very large (many 10s of Gigabytes). In order to improve the performance of the Workgroup Server and reduce the time required for backup there is a command line utility available to move old versions of network objects to an archive file. Other files in the in the workgroup database will not support archiving.
The following shows an example of how to use the archiving utility wdbarchive.exe.
The example below shows the archiving of a large InfoNet Collection Network for wdb file s134-4.wdb located in the default place for a database called MyDatabase.
- Ensure you are using a user account that has permission to access the Workgroup Server data file.
- Open a command prompt.
- Change directory to the location of the file:
cd /d C:\ProgramData\Innovyze\SNumbatData\MyDatabase.sndb
- Run the archiving utility:
“C:\Program Files\Innovyze Workgroup Data Server\wdbarchive” s134-4.wdb
- The file s134-4-archive.wdb will either have been created or new data add to the existing one.
- Once the archiving is done it is recommended that the main file is compacted with the command:
“C:\Program Files\Innovyze Workgroup Data Server\wdbcompact” s134-4.wdb
Network version control operations cannot be done by clients whilst the archiving is in progress. It is recommended to prevent clients from accessing the database whilst performing archiving, usually by stopping the Workgroup Server service.
The archiving may be interrupted by pressing control-C. This will save the archiving done so far, running the archive utility again will resume archiving.
The archive-wdb file is only modified by wdbarchive, therefore incremental file backups of the database files will be done much more quickly. Although the use of archiving will not reduce the overall storage needs of the database, it can make significant reductions in backup time where incremental file backups are used.