Update DVS_data.mdb

There are two options for operating DVS: offline and online. The offline version needs to be updated regularly, particularly to get the new monitoring data stored in ORACLE.

Updating the offline database DVS_data.mdb is not done by DVS but by opening directly the database DVS_data.mdb. Immediately after opening the file, a form pops up offering 3 options:

1. To update tables from the central database to the offline database
2. To view the log of recent successful updates
3. To exit the application (i.e close DVS_data.mdb)

In order to update tables from the central database to the offline database you must enter your ORACLE user name and password. You also have to select at least one table, otherwise the button is disabled.

As a rule, always the whole table is updated, not only the new records. For data security reasons (the connection to the database server may be interupted in the middle of the process), the update is achieved in the following 4 steps:

1. Copy the selected table from the central server into a temporary table in the local database (this will get all data, but not the definitions of primary keys and indexes from the remote database).
2. After successful data download, empty the local table to be updated.
3. Fill the local table with the contents of the temporary table (by this, locally defined primary keys and indexes will be maintained).
4. Delete the temporary table.

Note: Some of the monitoring data tables are very large. The repeated data adding and deletion may cause a significant increase in the file size of DVS_data.mdb. In that case, it is recommended to do a manual
Tools / Database Utilities / Compact and Repair Database ...

The automatic "Compact on Close" option is not recommended for DVS_data.mdb, as due to the filesize it may take several minutes each time the database is closed.