SCA (SQL Compatible Analysis) is compiled using Python (Version 3). SCA is a compatibility assessment tool used before migration of a heterogeneous database. It can evaluate whether the actual service SQL in the source database is executed in the target database and SQL performance difference in the two heterogeneous databases. Applicable to: MogDB and other openGauss-based databases
An SCA service program can run the following three tasks:
I [Inspection]: Compatibility assessment
Evaluates the compatibility of MogDB objects and service SQLs from Oracle to MogDB.
S [Simulation]: SQL simulation
Simulates the execution of Oracle service SQLs in the MogDB fidelity environment.
C [Collection]: Data collection
Collects Oracle metadata, including structure data of objects, SQL execution data, and other data.
- Compatibility assessment requires a complete source database structure. It is recommended that the MTK tool is used for migration of the source database structure. SCA can also be used to automatically create the structure of the target test database. However, the compatibility of the target test database created by SCA is relatively poor.
- SQL simulation requires a complete source database data. It is recommended that the MTK tool is used for migration of the source database structure and data.
SCA supports the following OSs and platforms currently:
- Linux x86_64
- Linux arm64
- MacOS (MacOS does not support the SHA256 encryption authentication mode of openGauss/MogDB.)
SCA supports the following source and target databases currently:
- Source database: Oracle >= 10.2
- Target database: MogDB/openGauss >= 1.0 (MacOS does not support the SHA256 encryption authentication mode.)
Note: Whether SCA supports a platform does not have relevance to whether SCA supports a database. A database running on other platforms, such as Windows/AIX can be supported by SCA only when the the host network and port are connected between the database and SCA.