CMS Snapshot Analysis - Run Analyzer - T-SQL - Information - How to modify schema name in T-SQL extraction before analysis

Purpose (problem description)

With the T-SQL offline analyzer, changing the server and/or instance from where the extraction is done leads to the change of all DB objects fullname. As consequence, all DB objects will be seen as added/removed. To avoid this problem, please follow below stepsbefore generating a new snapshot. If the new snapshot has been generated before doing these steps, you will need to delete the last snapshot and apply the steps mentioned below.

Observed in CAST AIP

ReleaseYes/No
8.3.x✅

Observed on RDBMS

RDBMSYes/No
CSS✅

Details

Steps to modify server and/or instance name without generating added/deleted DB objects for 7.2 / 7.3 version

Steps
Procedure
1

In CMS Add version and package and deliver in DMT.
In CMS, " accept deliver and set it as current version"
Edit the uax files of the latest extraction direct in the deployment folder to keep the same Instance name:

    1. In DatabaseExtraction.uaxdirectory
      • ... < UAXFile path="p_Instance.x.uax" name="X'Y'Z'" type="CAST_MSTSQL_Instance"> ..
    2. In p_Instance.x.uax
      • <instance id="p_Instance.1" instanceOf="CAST_MSTSQL_Instance">
        <CAST_SQL_Object version="9.00.1399.06"/>
        <CAST_Machine hostName="XYZ"/>
        collatorName="ABC" lcid="1033" codePage="1252" comparisonStyle="196609"/>
        <CAST_SQL_Area DBMSType="MSSQLServer"/>
        <CAST_Resolution_Identification resolutionName="X'Y'Z'"/>
        </instance> ...

        where:

        XYZ is the previous server name
        X'Y'Z' is the previous instance name
        ABC is the collation

2Run Analysis and snapshot

Notes/comments

Related Pages