Merging Sessions

Administrator User Guide

Project Administration : Data Options on the Main Menu : Merging Sessions

AVEVA E3D™ sessions enable a history of changes to the database to be recorded. When a new session is made, the changed data is appended to the end of the database file. Appending updated data to files will increase the disk space required. If the history information is not required, and to save disk space, you can compact a database by merging sessions. You can specify that the changes up to or after a given date, session number or Stamp will be merged.

For example, there may be a session which corresponds to a project milestone which you need to keep, in which case you can merge the sessions around this. In other cases you may wish to merge all sessions up to a given date, within a given week or after a specific Stamp. Merging the database sessions has no effect on any database references into that database from other databases.

To merge sessions, select Data > Change Management > Merge Changes from the main Admin menu. The Merge Changes form will be displayed.

You can merge the changes to All Project Databases, the System databases, or the Single database selected above.

If you choose All Project databases, you can merge all changes, or changes up to or after a given time, date, session number or Stamp.

If you choose System database, you can merge changes up to or after a given time, date, session number or Stamp.

If you choose Single database, choose a database from the Available databases list. The Database Sessions button will display the Database Sessions form, which lists information about the existing sessions for the database.

The Rebuild list button is used to update the list of databases. For example, if a new database has been created while the form is displayed, the list will not be updated until the form is closed and re-displayed, or click Rebuild list.

(Refer to Merging Changes for Extracts for information about merging sessions in extracts.)

After specifying the sessions to merge, click Apply to merge changes. Some session data will be deleted. The sessions remaining are those that you have either kept deliberately, or stamped sessions, as these are considered permanent and are not merged.