Who is this article for?

Administrators who want to export system data when their contract ends.

Admin permissions and SQL Server access are required.

When you end your hosting agreement with us, your server will be deleted. We understand you may want to retrieve your data before it becomes unavailable. This article describes various methods for exporting your information from the system.

1. Application
2. Database
3. Single-user instance on-prem

1. Application

There are three methods you can use to export data from the application while it is still online:

• Building appropriate views on the data grid, containing the required columns and rows, then using the Export to Excel function.
  There is a practical limit on the number of rows/columns that can be exported at any time, so it is necessary to use filters and run multiple exports.
• Using the standard and custom Audit report templates.
• Creating an offline version of the application using the Export read-only function.  

2. Database

At the end of the contract, we will offer you the option of downloading a backup copy of the SQL Server database where your data is stored.

This can be restored to a server on your own network, and someone with the relevant skills can extract data. Documentation of the database schema is available from here:  Overview of data organisation within the database (data dictionary/schema/entity relationships) – Ideagen Internal Audit • Aura | Help | Ideagen Luminate

3. Single-user instance on-prem

Another possibility is setting up a self-contained single user system on your own network, as a reference system.

This is possible, but note that:

• It would be necessary to purchase the required licenses.
• This would be treated as a new implementation of the application (using the existing database rather than a blank one). 
  The setup and installation activity would not be classed as standard support, and so it may be necessary to purchase implementation services.