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 steps before 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
Release
Yes/No
8.3.x(tick)
Observed on RDBMS
RDBMS
Yes/No
CSS(tick)
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