Page tree
Skip to end of metadata
Go to start of metadata
Note that these instructions are valid for the T-SQL and PL/SQL technologies.

When a database/schemas is delivered in V1 from Server A / Instance 1 and is then delivered in V2 from Server B / Instance 2 the default behavior on re-analysis of the same database/schema on a different Server or Instance will consider that the database/schema is in fact two separate databases/schemas even though they have the same name. This causes "noise" when consulting version comparison data (the database/schema will appear as deleted / added between V1 and V2 snapshots), in violation monitoring (removed / added) and it invalidates the content of the Action Plan.

If you find yourself in this situation, you can use a tool provided by CAST that will automatically modify the V2 database/schema extraction data to contain the same Server / Instance name as used in V1. In this way, the database/schema will not be considered new in snapshot V2. The tool must be run BEFORE you generate the V2 snapshot. To do so:

  • In the CAST Management Studio, open the Application containing your Microsoft/Sybase database Analysis Unit.
  • Click the Content Enrichment tab:

  • In the Tools before analysis section, click the  button and select Add new external program:

  • In the configuration panel, fill in the following fields:
1Enter a name for the tool "job" - use a name that is easy to distinguish.
2Ensure the Will be processed option is selected
3Enter the path to the TKBTools.exe file which can be found in the root of your CAST installation folder.
4

Enter the following arguments in the Program arguments field:

-INSTANCE_NAME "old_instance_name" -DEPLOYED_PACKAGE_PATH "deployed_package_path"

So, for example if the database/schema in V1 was extracted by the CAST Delivery Manager Tool from Instance "INSTANCE_A" and the database/schema extraction in V2 was deployed to the Deployment path "D:\Deploy\MEUDON\TSQL_PACKAGE", you would enter the following arguments:

-INSTANCE_NAME "INSTANCE_A" -DEPLOYED_PACKAGE_PATH "D:\Deploy\MEUDON\PACKAGE_NAME"

This will modify the V2 extraction data in "D:\Deploy\MEUDON\PACKAGE_NAME" and ensure that the instance name is changed to the instance used in V1 (INSTANCE_A).

  • Close the configuration panel. You should now see the tool "job" displayed as follows:

  • Whenever you run the V2 analysis, the tool job will also be run ensuring that the V2 extraction data is modified to match the V1 instance name.
  • Remember to modify the tool "job" in V3 if the schema is being delivered from a new instance in V3.
If a Oracle schema has been moved from one server/instance to another, you should ensure that the original and the new schema are fully identical. Any differences will be picked up by the CAST analyzer. In particular, the Oracle IDs (OIDs) must be maintained: CAST recommends using the impdp parameter transform=OID:y:type to move the schema. This will preserve the original OID values.
  • No labels