FileAudit Documentation
FileAudit Documentation
You are here: Reference > Advanced > Maintenance > Database manager

Database manager

Starting from FileAudit 6.4, the Event Cleaner tile is now replaced by the Database Manager tile.

The new section regroups all features related to managing your database including editing, migrating and archiving. You can monitor the size of your database, as well as set up scheduled cleaning or archiving tasks if you need to retain auditing records.

Edit

This allows you to change your production database. Take note that if you wish to keep your current data visible in FileAudit, you should perform a migration instead.

To edit your production database:

  1. Click on “Edit” in the Database manager view

  2. Select the destination database provider, then click on the three dots "..." at the end of the “Connection string” text field to configure the destination database connection string

  3. Select the type of database connection for your destination database and click “OK”

  4. Depending on which database connection you chose, configure the properties of your database

  5. Once your destination database is configured, click on “Save”

Migrate

Available in FileAudit 6.4, this feature allows you to transfer data from your production database to another database. Once the data has been transferred, the new destination database becomes the FileAudit production database. To use this feature:

  1. Click on “Migrate”

  2. Select the destination database provider, then click on the three dots "..." at the end of the “Connection string” text field to configure the destination database connection string

  3. Select the type of database connection for your destination database and click “OK”

  4. Depending on which database connection you chose, configure the properties of your database

  5. Once your destination database is configured, click on the green “Next” button

  6. Click on “Migrate”

Archive

FileAudit 6.4 integrates the new database archiving feature which allows you to entirely or partially archive your production database. This action moves data from your production database to a destination database. You can also choose to keep data up to a certain amount of days in the production database. To use this feature:

  1. Click on “Archive”

  2. Select the destination database provider, then click on the three dots "..." at the end of the “Connection string” text field to configure the destination database connection string

  3. Select the type of database connection for your destination database and click “OK”

  4. Depending on which database connection you chose, configure the properties of your database

  5. Once your destination database is configured, set the number of days to keep in your production database (set “0” (zero) if you want to entirely archive your production database) and then click on “Next”

  6. Click on “Archive”

Tip: You can restore a database that was archived to audit it again. Two ways to do that. If you want to restore its data only, you can use the archived database as your production database. If you want to keep your current database and merge its data with the archived database, just follow the migration procedure using your production database as source and the archived one as destination.

Clean

Starting with FileAudit 6.4, the one-shot cleaning is now replaced by the “Clean” button. To use this feature:

  1. Click on “Clean”

  2. Select the operation you want to process

  3. If you chose “Erase records older than”, configure the number of days for which you would like to keep records

  4. Click on “Run”

Scheduling

This feature allows you to configure a scheduled task for cleaning or archiving your data.

You can configure a complete or partial scheduled archiving by selecting “Archive all events” in the “Operation” text field, or “Archive events older than” and setting the number of days to keep in the text field at the right of the “day(s)” label. The scheduled cleaning is still available for erasing records.