2.6 Planning the SQL Database

The SQL start guides are included here as a courtesy. It is your responsibility to find the proper installation procedures and documentation from your chosen database vendor. The entire responsibility for installation, care, and maintenance of the database server lies with you. Micro Focus does not provide any kind of support for the database server for legal and other reasons.

Retain must have database owner rights to the SQL database it is connected to.

2.6.1 Supported SQL Database Platforms

2.6.2 Configuration and Message Store Databases

  • Retain prompts you for access information to your SQL Database Server

    • You must create this database beforehand. (See system requirements for documentation for the supported SQL servers.)

    • Retain creates the tables, indexes, and prepares the database for use

You are prompted to provide SQL connection information for both the configuration and message store databases. For convenience and simplicity most installations store this information in the same database. The databases are used to store Retain configuration, cached address books, and all saved message data.