Work with DB

Tab "DB maintenance" is designed to optimize a set of database operations.
In case reports have started to be generated much slower it makes sense to run the database reindexing.

The "Tables export" tab provides an intuitive interface for exporting popular database tables related to the complex settings.
If a table is not in the list, but it is in the database and needs to be exported, the name can be added.
Output format does not have to match the type of the current DB.
The export output will be one or several files in the format of a standard SQL-script, for subsequent launch through any utilities for working with SQL-scripts, or for use at the "Import of SQL-scripts" tab to import previously exported table data into the database.

Attention! After importing the table TDBUsers ("Database Users") you have to execute the "Database Configuration Wizard", it will add the created users to the database and assign them rights. In this case, only domain users will be created, but SQL users will not (they must exist in the database before the import)!