CHECK MIGRATION

Description

The CHECK MIGRATION LIST syntax is used to check data consistancy in migration job.

Syntax

Grammar Railroad diagram

ShowMigrationList ::=
  'CHECK' 'MIGRATION' migrationJobId 'BY' 'TYPE' '(' 'NAME' '=' migrationCheckAlgorithmType ')'
migrationJobId ::=
  string
migrationCheckAlgorithmType ::=
  string

Supplement

• migrationJobId needs to be obtained through SHOW MIGRATION LIST syntax query

• migrationCheckAlgorithmType needs to be obtained through SHOW MIGRATION CHECK ALGORITHMS syntax query

Example

• check data consistancy in migration job

CHECK MIGRATION 'j01016e501b498ed1bdb2c373a2e85e2529a6' BY TYPE (NAME='CRC32_MATCH');

Reserved word

CHECK, MIGRATION, BY, TYPE

Related links

• Reserved word
• SHOW MIGRATION LIST
• SHOW MIGRATION CHECK ALGORITHMS