RDBMS Move to Cloud - 1.0
Description
This extension provides a dedicated set of quality rules, i.e. recommendations, that have been designed to help plan a modernization project for taking an on premise RDBMS to the Cloud or to migrate to another RDBMS.
Results are shown in CAST Imaging Viewer and the CAST Engineering Dashboard. You can view the rules provided in this extension in the Structural Rules section below.
Supported database migration scenarios
Cloud Migration:
- Oracle Database to Oracle Cloud Database
Database Migration:
- DB2 Database to SQL Server
- DB2 Database to PostgreSQL
- Oracle Database to PostgreSQL
- SQL Server Database to PostgreSQL
- DB2 Database to MySQL
- DB2 Database to Oracle
- SQL Server to Azure SQL
Technical notes
- When an analysis contains two or more different types of RDBMS source code, the rules for each RDBMS are always calculated. E.g.: analyzing DB2 and Oracle SQL files will trigger Oracle and DB2 quality rules.
- When the RDBMS vendor is not detected and file is considered ANSI sql, quality rules are not calculated.
Function Point, Quality and Sizing support
This extension provides the following support:
- Function Points (transactions): a green tick indicates that OMG Function Point counting and Transaction Risk Index are supported
- Quality and Sizing: a green tick indicates that CAST can measure size and that a minimum set of Quality Rules exist
| Function Points (transactions) | Quality and Sizing |
|---|---|
| ❌ | ✅ |
Dependencies with other extensions
Some CAST extensions require the presence of other CAST extensions in order to function correctly. This extension requires that the following other CAST extensions are also installed:
- SQL Analyzer (≥ 3.7.13)
Note that any dependent extensions will be automatically downloaded and installed.
Download and installation instructions
The extension will not be automatically installed and instead requires a manual installation if you need to use it.
What results can you expect?
Structural rules
- 1.0.7-funcrel
- 1.0.6-funcrel
- 1.0.5-funcrel
- 1.0.4-funcrel
- 1.0.3-funcrel
- 1.0.2-funcrel
- 1.0.1-funcrel
- 1.0.0-funcrel
- 1.0.0-beta9
- 1.0.0-beta8
- 1.0.0-beta7
- 1.0.0-beta6
- 1.0.0-beta5
- 1.0.0-beta4
- 1.0.0-beta3
- 1.0.0-beta2
- 1.0.0-beta1
CAST Imaging Viewer
Results are provided in the Advisor:
CAST Engineering Dashboard
Example results for Oracle Database to Oracle Cloud:
Example results for Oracle Database to Amazon Aurora:
