Template:SQWareRepositoryPresSgbd

Presentation

It is the repository module, and stores rdbms indicators for {{{1}}}.
It's a {{{1}}} {{{2}}}. It is currently the only type of supported RDBMS for expdbTools® repository for {{{1}}}.
Each scheme is managed in the same type of RDBMS that managed to avoid client deployment problem (Oracle in Oracle, Sybase, Sybase ...). One exemption is Ingres, Ingres indicators are managed in a MySql database.
The first table to populate is the information repository of {{{1}}} {{{3}}}. It's tsqw_Repository table that conten basic informations of {{{3}}} to manage.

naming convention

All objects are named with prefixes:

• tsqw_% : for tables
• isqw_% : for index
• isqw_%_u : for uniques
• isqw_%_pk : for primary key