Summary: This document provides information about the analysis results you can expect from an analysis of SQL technologies using the legacy PL/SQL and T-SQL analyzers embedded in CAST AIP.
What results can you expect?
Once the analysis/snapshot generation has completed, you can view the results in the normal manner (for example via CAST Enlighten):
Microsoft SQL Server and Sybase ASE T-SQL
|Table Column / View Column|
|Index, Foreign Key Constraint, Primary Key Constraint, Unique Constraint|
Links detected by the SQL Analyzer are listed in the attached Excel file:
Collection Nested Table Type
Index, Foreign Key Constraint, Primary Key Constraint, Check Constraint and Unique Key Constraint
Object Type (Incomplete, Body and Header)
View (Normal and Materialized)
Object properties that are supported by the current release of the embedded SQL analyzer are described in the attached Excel file:
Links detected by the embedded SQL analyzer are listed in the attached Excel file: