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.
Transactions
Transaction support is derived from metamodel concepts used to build CAST Imaging Blueprint and structural transaction flows. Entry Points start transactions; Exit Points include both output/boundary concepts and Data Entities manipulated by transactions.
| Role | Support | Breakdown |
|---|---|---|
| Entry Point | No direct concept type details | |
| Exit Point | No direct concept type details |
Data version: 1.0.9-funcrel
ISO 5055 Structural Rules
Quality support is based on ISO 5055 structural rules available for the selected extension version.
| Reliability | Maintainability | Security | Performance Efficiency |
|---|---|---|---|
Data version: 1.0.9-funcrel
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.9-funcrel
- 1.0.8-funcrel
- 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:
