Database

Database

This branch contains database maintenance functions.

Referesh Database - use this button to refresh all databases from SQL server instance and display them on a list.

Diagnose - run diagnose to see results for selected databases.

Diagnose indexes shows poorly used indexes since server SQL restart and missing indexes by index advantage according to SQL server engine.

Also see:

• Company settings - for creating a new database based on an existing one
• Backup - for creating and restoring backup copies of databases and executables
• Statistics - for statistical information about the database
• Referential Integrity Check - for checking the referential integrity of the database
• Import/Export Data - for importing and exporting data to and from specific tables
• Document Links and Transfers with the items:
  • Document Links
  • Transfer Docs. Between Doc. Types
  • Insert Documents
  • Transfer Documents
• System Log
• Report Log
• Changelog Settings
• Locked Records