Target audience:

Users of the extension providing SQL move to cloud recommendations for the SQL Analyzer extension.

Summary: This document provides information about the extension that provides SQL move to cloud recommendations for the SQL Analyzer extension (≥ 3.6.7)

Extension ID

com.castsoftware.sql.movetocloud

What's new?

Please see RDBMS Move to Cloud - 1.0 - Release Notes for more information.

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 (Oracle Cloud / Amazon Aurora). You should install this extension:

If you need to have a set of recommendations because you plan to move from Oracle Database to Oracle Cloud
If you need to have a set of recommendations because you plan to move from Oracle Database to Amazon Aurora

Results are shown in the CAST Engineering Dashboard. You can view the rules provided in this extension in the Structural Rules section below.

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

AIP Core compatibility

This extension is compatible with:

AIP Core release	Supported
8.3.x

Supported DBMS servers used for AIP Core schemas

This extension is compatible with the following DBMS servers used to host AIP Core schemas:

AIP Core release	CSS/PostgreSQL
All supported releases

Dependencies with other extensions

Some CAST extensions require the presence of other CAST extensions in order to function correctly. The RDBMS Move to Cloud extension requires that the following other CAST extensions are also installed:

SQL Analyzer (≥ 3.6.7)

Note that when using CAST Console to download and install the extension, any dependent extensions are automatically downloaded and installed.

Prerequisites

	An installation of any compatible release of AIP Core (see table above).
	An installation of SQL Analyzer extension (≥ 3.6.7).

Download and installation instructions

The extension will not be automatically downloaded and installed in CAST Console. If you need to use it, should manually install the extension using the Application - Extensions interface:

What results can you expect?

Structural rules

1.0.0-beta3	https://technologies.castsoftware.com/rules?sec=srs_sql.movetocloud&ref=\|\|1.0.0-beta3
1.0.0-beta2	https://technologies.castsoftware.com/rules?sec=srs_sql.movetocloud&ref=\|\|1.0.0-beta2
1.0.0-beta1	https://technologies.castsoftware.com/rules?sec=srs_sql.movetocloud&ref=\|\|1.0.0-beta1

Example results for Oracle Database to Oracle Cloud:

Click to enlarge

Example results for Oracle Database to Amazon Aurora: