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, PostgreSQL, Informix, SQL Server.

Applicable to: MogDB and other openGauss-based databases

The SCA program can run the following 14 types of tasks:

• Tasks related to program operation:

  1. I [Initialize]: Initialization, used for initializing the SCA database.
  2. L [Apply License]: License application, used for tasks related to license applications.

• Tasks related to collection:

  1. OC [Oracle Collection]: Oracle collection, used for collecting business SQLs executed in Oracle databases, requires long-term collection.
  2. MC [MySQL Collection]: MySQL collection, used for collecting business SQLs executed in MySQL databases, requires pre-configuration of slow logs, then collected all at once.
  3. DC [DB2 Collection]: DB2 collection, used for collecting business SQLs executed in DB2 databases, requires long-term collection.
  4. PC [PostgreSQL Collection]: PostgreSQL collection, used for collecting business SQLs executed in PostgreSQL databases (dependent on the pg_stat_statements plugin), requires long-term collection.
  5. IC [Informix Collection]: Informix collection, used for collecting business SQLs executed in Informix databases (manual activation of global sql trace function required), requires long-term collection.
  6. SC [SQL Server Collection]: SQL Server collection, used for collecting business SQLs executed in SQL Server databases, requires long-term collection.

• Tasks related to analysis:

  1. OI [Oracle Inspection]: Oracle compatibility assessment, used to assess the actual compatibility of business SQLs collected from the source Oracle in the target MogDB.
  2. MI [MySQL Inspection]: MySQL compatibility assessment, used to assess the actual compatibility of business SQLs collected from the source MySQL in the target MogDB.
  3. DI [DB2 Inspection]: DB2 compatibility assessment, used to assess the actual compatibility of business SQLs collected from the source DB2 in the target MogDB.
  4. PI [PostgreSQL Inspection]: PostgreSQL compatibility assessment, used to assess the actual compatibility of business SQLs collected from the source PostgreSQL in the target MogDB.
  5. II [Informix Inspection]: Informix compatibility assessment, used to assess the actual compatibility of business SQLs collected from the source Informix in the target MogDB.
  6. SI [SQL Server Inspection]: SQL Server compatibility assessment, used to assess the actual compatibility of business SQLs collected from the source SQL Server in the target MogDB.
  7. OS [Oracle Simulation]: Oracle performance assessment, used to assess the execution performance of business SQLs collected from the source Oracle in the target MogDB.
  8. OIS [Oracle Inspection & Simulation]: Oracle compatibility and performance assessment, equivalent to conducting both OI + OS tasks simultaneously.

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 for test purposes.
• 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
   • PostgreSQL >= 9
   • Informix >= 14.10 (lower version does not verified)
   • SQL Server >= 16.0 (lower version does not verified)
   • 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.