Multiple CA DevTest Registries connecting to database w/ multiple schemas

book

Article ID: 6968

calendar_today

Updated On:

Products

CA Application Test Service Virtualization CA Continuous Application Insight (PathFinder) CA Service Virtualization (DevTest / LISA / VSE / Application Test)

Issue/Introduction

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?

 

Cause

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

Environment

All supported DevTest releases and platforms.

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.