Detailed technology support
Microsoft SQL Server
|Language version||Supported||Supported by reference||Deprecated||Comments|
Microsoft T-SQL 2005
|Supported with limitations: Some syntax is not supported. See section below entitled Unsupported Microsoft SQL-Server syntax for Microsoft SQL Server.|
Microsoft T-SQL 2008
|Microsoft T-SQL 2012||Supported with limitations: New syntax introduced in Microsoft T-SQL 2012 and 2014 is not supported.|
|Microsoft T-SQL 2014|
|Supported||Supported by reference||Deprecated|
Sybase T-SQL 12.0
Sybase T-SQL 12.5.x with x ≤ 3
Supported with limitations: Some syntax is no supported. See section below entitled Unsupported Sybase ASE 12.5.x syntax (see elements in bold).
Sybase T-SQL 12.5.4
Supported with limitations: Databases should be at syntax level 12.5.3 or lower. New syntax introduced in later versions is not supported.
Sybase T-SQL 15.0+ESD#2
Sybase T-SQL 15.5
|Sybase T-SQL 15.7|
Required third-party software
To successfully deliver and analyze Microsoft SQL Server or Sybase ASE T-SQL code, the following third-party software is required:
Install on workstation running the DMT (for extraction)
Install on workstation running CMS (for analysis)
All that is required is network access to the live database/schema to be packaged.
Microsoft SQL Server and Sybase ASE T-SQL objects and links
The following section lists the objects and links between objects that the SQL analyzer is capable of detecting and storing in the CAST Analysis Service:
|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:
Technology support notes
This section provides more detail about the support for specific Microsoft SQL Server and Sybase ASE syntax and the way in which CAST handles them:
- For duplicated objects (objects with the same name belonging to the same database but with different users), only one of the objects is managed.