Search TipsAbout Cadcorp SIS Archive Manager
Cadcorp SIS Archive Manager has been designed to enhance the management of spatial data within a PostGIS or SQL Server database. Data stored within business critical layers can be archived to ensure that information is never permanently lost. The system automatically creates a copy of data that has been edited or deleted from the layer.
Use the Archive Manager to step back in time and view historic data for a given spatial layer.
How does it work?
When data is edited or deleted from a database, the original information is over-written and no longer available. This means it is not possible to see the data as it was before being edited or deleted.
In addition, metadata is not recorded against new changes. Users have no information about who created the data or when it was created.
The Archive Manager records the name of the user making the edit and the time the edit was made. This can be compared with:
- The original feature now moved to the archive table.
- The current feature in the main table.
TIP: Unwanted edits can be undone by copying historic data from the archive table back into the main table.