Multiple CA DevTest Registries connecting to database w/ multiple schemas

Document ID : KB000006968
Last Modified Date : 14/02/2018
Show Technical Document Details
Issue:

We are currently Installing CA DevTest to 10.1 on two linux boxes. We have deployed the standard DDL's onto 2 separate schema's per instructions from conversations had with CA. In the documentation, it states that manual deployments are possible. My question is how do we configure the registry to point to different schema before registry service start?

 

Environment:
All supported DevTest releases and platforms.
Cause:

After reviewing your SQL Server you have 1 database, but that database has 2 sets of Registry tables, being differentiated by a prefix.

Resolution:

DevTest can only connect to the Registry based on its connection string for SQL Server in the site.properties file. There is no way to specify a set of DevTest tables based on its prefix in the connection string. Registries and Enterprise Dashboards must each have a unique schema (database), so it is not possible not point multiple registries at the same database. You will have to change the one database with the 2 sets of table to only have one set.