Multiple Registries connecting to database with multiple schemas

Products

• CA Application Test
• CA Continuous Application Insight (PathFinder)

Issue/Introduction

Currently Installing CA DevTest on two linux boxes.

Have deployed the standard DDL's onto 2 separate schema's per instructions from conversations had with support.

In the documentation, it states that manual deployments are possible.

Question is how to configure the Registry to point to different schema before Registry service start?

 

Environment

All supported DevTest releases and platforms.

Cause

After reviewing the SQL Server, there is only 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. Need to change the one database with the 2 sets of tables to only have one set.