SHOW MIGRATION CHECK ALGORITHM

Description

The SHOW MIGRATION RULE syntax is used to query migration check algorithm.

Syntax

  1. ShowMigrationCheckAlgorithm ::=
  2.   'SHOW' 'MIGRATION' 'CHECK' 'ALGORITHMS'

Return Value Description

ColumnDescription
typemigration check algorithm type
supported_database_typessupported database type
descriptionDescription of migration check algorithm

Example

  • Query migration check algorithm
  1. SHOW MIGRATION CHECK ALGORITHMS;
  1. mysql> SHOW MIGRATION CHECK ALGORITHMS;
  2. +-------------+--------------------------------------------------------------+----------------------------+
  3. | type        | supported_database_types                                     | description                |
  4. +-------------+--------------------------------------------------------------+----------------------------+
  5. | CRC32_MATCH | MySQL                                                        | Match CRC32 of records.    |
  6. | DATA_MATCH  | SQL92,MySQL,MariaDB,PostgreSQL,openGauss,Oracle,SQLServer,H2 | Match raw data of records. |
  7. +-------------+--------------------------------------------------------------+----------------------------+
  8. 2 rows in set (0.03 sec)

Reserved word

SHOW, MIGRATION, CHECK, ALGORITHMS