HomeMogDBMogDB StackUqbar
SCA
SQL Compatibility Analyzer

Documentation:v5.0

Supported Versions:

Overview of SCA

SCA (SQL Compatibility Analyzer) is an SQL compatibility and performance evaluation tool for heterogeneous databases prior to migration.

SCA is used to assess the compatibility of heterogeneous data before migration, to assess whether the actual business SQL in the source database has syntax problems in the target database, and to assess the performance differences between the actual execution of SQL in the two heterogeneous databases.

SCA currently supports three source databases, including: Oracle, MySQL, DB2.

Applicable to: MogDB and other openGauss-based databases

SCA service program can run the following 10 types of tasks:

  1. I [Initialize]: Initialize, used to initialize the SCA repository
  2. L [Apply License]: Apply license, task for license application
  3. OC [Oracle Collection]: Oracle collection, used to collect the business SQL executed in Oracle database, need long time to collect
  4. MC [MySQL Collection]: MySQL collection, used to collect the business SQL executed in MySQL database, need to configure the slow log in advance, and then collect at once
  5. DC [DB2 Collection]: DB2 collection, used to collect the business SQL executed in DB2 database, need long time to collect
  6. OI [Oracle Inspection]: Oracle compatibility evaluation, used to evaluate the actual compatibility of business SQL collected in Oracle on the source side in MogDB on the target side
  7. MI [MySQL Inspection]: MySQL compatibility evaluation, used to evaluate the actual compatibility of business SQL collected in MySQL on the source side in MogDB on the target side
  8. DI [DB2 Inspection]: DB2 compatibility evaluation, used to evaluate the actual compatibility of business SQL collected in DB2 on the source side in MogDB on the target side
  9. OS [Oracle Simulation]: Oracle performance evaluation, used to evaluate the execution performance of business SQL collected in Oracle on the source side in MogDB on the target side
  10. OIS [Oracle Inspection & Simulation]: Oracle compatibility and performance evaluation, equivalent to OI + OS two tasks at the same time

Note:

  • Compatibility assessment requires a complete source database structure. It is recommended that MTK is used for migration of the source database structure. SCA can also be used to automatically create a target test database but its compatibility is relatively poor.
  • SQL simulation requires a complete source database data and data. It is recommended that MTK is used for migration of the source database structure and data.

Supported OSs and Platforms

SCA supports the following OSs and platforms currently:

  1. Linux x86_64
  2. Linux arm64 (ARM platform does not support DB2 data collection because it does not have a DB2 client)
  3. MacOS (MacOS does not support the SHA256 encryption authentication mode of openGauss/MogDB.)

Supported Databases

SCA supports the following source and target databases currently:

  1. Source database:
    • Oracle >= 10.2
    • MySQL >= 5.5
    • DB2 >= 11.5
    • File: MySQL slow-log
  2. Target database:
    • MogDB/openGauss >= 2.0
    • PostgreSQL >= 13.0

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.

Copyright © 2011-2024 www.enmotech.com All rights reserved.