Preparing databases for the multiuser mode

You can use Tosca Commander in either single or multiuser mode (see chapter "Multiuser mode").

If you use the multiuser mode, Tosca Commander uses common repositories to centrally manage projects in databases (see chapter "Connecting Common Repositories").

The following repository types are available for multiuser environments:

For further information on supported versions, see the System Requirements.

Preparing an MS SQL Server for common repositories

Please perform the following preparatory steps to create an MS SQL server or Microsoft Azure SQL, the cloud-based solution of the SQL server for common repositories:

  • Create tables with the supplied SQL script in the database. The script is located at %COMMANDER_HOME%\SQL\ in standard installations. The script for the SQL server is located in the directory MS SQL Server, and for Azure SQL it is located in the Azure SQL Server directory.

    The access rights CREATE, ALTER are required if tables are created for the first time (database role db_owner).

Administrators must adapt the script to local requirements and conditions prior to usage.

  • The SQL server must have a user who has the following access rights to all tables of the common repository: SELECT, INSERT, UPDATE and DELETE (database roles db_owner, db_datawriter and db_datareader).

  • DROP rights are needed to delete a schema (database role db_owner).

Database administrators may adjust the following settings in order to improve management of common repositories on Microsoft SQL servers:

Preventing deadlocks

SNAPSHOT_ISOLATION can be activated for the database in order to prevent deadlocks. Database administrators can use the following statements:

ALTER DATABASE <databasename> SET ALLOW_SNAPSHOT_ISOLATION ON

ALTER DATABASE <databasename> SET READ_COMMITTED_SNAPSHOT ON

<databasename> must be replaced according to the actual name of the database.

Tricentis recommends activating the SNAPSHOT_ISOLATION to prevent deadlocks.

Defragmenting indexes

You can enhance the performance of common repositories if indexes are defragmented on a daily basis.

Tricentis Tosca comes with the sample script Rebuild Indexes MSSQL.sql in the directory %COMMANDER_HOME%\SQL\MS SQL Server. You can utilize this script for daily defragmenting after the database administrator has adapted it according to the local conditions.

Preparing DB2 for common repositories

Please perform the following preparatory steps to create a DB2 database for common repositories:

  • Create tables in the DB2 database by using the supplied SQL script. In standard installations, this script is located at
    %COMMANDER_HOME%\SQL\DB2).

    The access rights CREATE, ALTER are required if tables are created for the first time.

Please note that an administrator must adapt the script to meet specific requirements before use.

  • The DB2 server must have a user who has the following access rights to all tables of the common repository: SELECT, INSERT, UPDATE and DELETE.

  • DROP rights are needed to delete a schema.

Preparing Oracle for common repositories

Please perform the following preparatory steps to create an Oracle database for common repositories:

Preparing the client

  • The corresponding Oracle client components must be installed on the client PC.

  • Tosca uses ODP.NET Version 2.112.4.0 (32bit and 64bit). The Oracle Data Provider must be registered in the GAC by using the OraProvCfg.exe file.

Preparing the database

  • Create tables in the Oracle database by using the supplied SQL script. In standard installations, this script is located at
    %COMMANDER_HOME%\SQL\Oracle).

    The access rights CREATE and ALTER are required if tables are created for the first time.

Please note that an administrator must adapt the script to meet specific requirements before use.

  • The Oracle server must have a user who has the following access rights to all tables of the common repository: SELECT, INSERT, UPDATE and DELETE.

  • DROP rights are needed to delete a schema.

Preparing SQLite for common repositories

If you would like to use SQLite with a common repository, you do not need to prepare a database. Simply proceed as described in chapter "Creating the Repository type SQLite".