Evacuating archives to SQL database

The database table <Project name>_<shortcut> gained two columns.

GUID: Contains the project GUID of the variable from another project or is ZERO if in the own project.
STRVALUE: varchar. Contains the archived string values. For numerical variables this field has the value ZERO.
The length of the varchar datafield depends on the longest string variable to be archived. The length of the string variable is defined in the variable properties.

The database table <project name>_VARIABLES has one more column:

GUID: Contains the project GUID of the variable from another project or is ZERO if in the own project.

These new columns either have to be added to the SQL database by hand, or they are added from the Editor. In the Editor you have to switch to the to the property page Save in all concerned archives. There you open the connection string to the database and confirm the dialog. On closing the dialog the changes in the database are done.

Attention

If these changes are not done, no archive data will be evacuated to the SQL database.