tencent cloud

PrevNext

Feedback

search by keyword

Recent Pages

Documentation
Data Transfer Service
    Documentation
    Download PDF

    Data Types

    Last updated: 2024-07-24 10:31:18
    Download PDF

      CheckStep

      Check step

      Used by actions: DescribeMigrationCheckJob.

      Name Type Description
      StepNo Integer Step number
      Note: This field may return null, indicating that no valid values can be obtained.
      StepId String Step ID such as ConnectDBCheck, VersionCheck, and SrcPrivilegeCheck. The specific check items are subject to source and target instances.
      Note: This field may return null, indicating that no valid values can be obtained.
      StepName String Step name
      Note: This field may return null, indicating that no valid values can be obtained.
      StepStatus String Result of this check step. Valid values: pass, failed, notStarted, blocked, warning.
      Note: This field may return null, indicating that no valid values can be obtained.
      StepMessage String Error message in this check step
      Note: This field may return null, indicating that no valid values can be obtained.
      DetailCheckItems Array of DetailCheckItem Specific check item in this check step
      Note: This field may return null, indicating that no valid values can be obtained.
      HasSkipped Boolean Whether this step was skipped
      Note: This field may return null, indicating that no valid values can be obtained.

      CheckStepInfo

      Check task running details

      Used by actions: DescribeMigrationDetail.

      Name Type Description
      StartAt String Task start time
      Note: This field may return null, indicating that no valid values can be obtained.
      EndAt String Task end time
      Note: This field may return null, indicating that no valid values can be obtained.
      Progress ProcessProgress Task step information
      Note: This field may return null, indicating that no valid values can be obtained.

      Column

      Column information in data sync

      Used by actions: ConfigureSyncJob, DescribeSyncJobs, ModifySyncJobConfig.

      Name Type Required Description
      ColumnName String No Column nameNote: This field may return null, indicating that no valid values can be obtained.
      NewColumnName String No New column name
      Note: This field may return null, indicating that no valid values can be obtained.

      CompareAbstractInfo

      Summary information of data consistency check

      Used by actions: DescribeCompareReport.

      Name Type Description
      Options CompareOptions Configuration parameters of the check task
      Note: This field may return null, indicating that no valid values can be obtained.
      Objects CompareObject Consistency check objects
      Note: This field may return null, indicating that no valid values can be obtained.
      Conclusion String Comparison conclusion. Valid values: same, different.
      Note: This field may return null, indicating that no valid values can be obtained.
      Status String Task status. Valid values: success, failed.
      Note: This field may return null, indicating that no valid values can be obtained.
      TotalTables Integer Total number of tables
      Note: This field may return null, indicating that no valid values can be obtained.
      CheckedTables Integer Number of checked tables
      Note: This field may return null, indicating that no valid values can be obtained.
      DifferentTables Integer Number of inconsistent tables
      Note: This field may return null, indicating that no valid values can be obtained.
      SkippedTables Integer Number of skipped tables
      Note: This field may return null, indicating that no valid values can be obtained.
      NearlyTableCount Integer The estimated number of tables
      Note: This field may return null, indicating that no valid values can be obtained.
      DifferentRows Integer Number of inconsistent data rows
      Note: This field may return null, indicating that no valid values can be obtained.
      SrcSampleRows Integer Source database row count, which takes effect only when the comparison type is Row count comparison.
      Note: This field may return null, indicating that no valid values can be obtained.
      DstSampleRows Integer Target database row count, which takes effect only when the comparison type is Row count comparison.
      Note: This field may return null, indicating that no valid values can be obtained.
      StartedAt String Start time
      Note: This field may return null, indicating that no valid values can be obtained.
      FinishedAt String End time
      Note: This field may return null, indicating that no valid values can be obtained.

      CompareDetailInfo

      Data consistency check details

      Used by actions: DescribeCompareReport.

      Name Type Description
      Difference DifferenceDetail Details of inconsistent tables
      Note: This field may return null, indicating that no valid values can be obtained.
      Skipped SkippedDetail Details of skipped tables
      Note: This field may return null, indicating that no valid values can be obtained.

      CompareObject

      Configuration of the data consistency check object

      Used by actions: CreateCompareTask, DescribeCompareReport, DescribeCompareTasks, ModifyCompareTask.

      Name Type Required Description
      ObjectMode String Yes Data comparison object mode (all: Entire instance; partial: Some objects)
      Note: This field may return null, indicating that no valid values can be obtained.
      ObjectItems Array of CompareObjectItem No Object list
      Note: This field may return null, indicating that no valid values can be obtained.
      AdvancedObjects Array of String No Advanced object type (account: Account; index: Index; shardkey: Shard key, which may be adjusted later; schema: Database/table structure)
      Note: This field may return null, indicating that no valid values can be obtained.

      CompareObjectItem

      Database/Table objects for data consistency check

      Used by actions: CreateCompareTask, DescribeCompareReport, DescribeCompareTasks, ModifyCompareTask.

      Name Type Required Description
      DbName String Yes Database name
      Note: This field may return null, indicating that no valid values can be obtained.
      DbMode String Yes Database selection mode. Valid values: all, partial.
      Note: This field may return null, indicating that no valid values can be obtained.
      SchemaName String No Schema name
      Note: This field may return null, indicating that no valid values can be obtained.
      TableMode String No Schema selection mode. Valid values: all, partial.
      Note: This field may return null, indicating that no valid values can be obtained.
      Tables Array of CompareTableItem No Table configuration for data consistency check, which is required if TableMode is partial.
      Note: This field may return null, indicating that no valid values can be obtained.
      ViewMode String No View selection mode. Valid values: all, partial.
      Note: This field may return null, indicating that no valid values can be obtained.
      Views Array of CompareViewItem No View configuration for data consistency check, which is required if ViewMode is partial.
      Note: This field may return null, indicating that no valid values can be obtained.

      CompareOptions

      Consistency check options

      Used by actions: CreateCompareTask, DescribeCompareReport, DescribeCompareTasks, ModifyCompareTask.

      Name Type Required Description
      Method String No Comparison type: (dataCheck: Full data comparison; sampleDataCheck: Sampling data comparison; rowsCount: Row count comparison)
      Note: This field may return null, indicating that no valid values can be obtained.
      SampleRate Integer No Sampling rate. Value range: 0-100%.
      Note: This field may return null, indicating that no valid values can be obtained.
      ThreadCount Integer No The number of threads, which defaults to 1. Value range: 1-5.
      Note: This field may return null, indicating that no valid values can be obtained.

      CompareTableItem

      Table configuration for data consistency check

      Used by actions: CreateCompareTask, DescribeCompareReport, DescribeCompareTasks, ModifyCompareTask.

      Name Type Required Description
      TableName String No Table name
      Note: This field may return null, indicating that no valid values can be obtained.

      CompareTaskInfo

      Data consistency check result

      Used by actions: DescribeMigrationDetail, DescribeMigrationJobs.

      Name Type Description
      CompareTaskId String Data consistency check task ID
      Note: This field may return null, indicating that no valid values can be obtained.
      Status String Data consistency check result. Valid values: unstart (the task is not started); running (the task is running); canceled (the task is stopped); failed (the task failed); inconsistent (the data is inconsistent); consistent (the data is consistent); notexist (the task does not exist).
      Note: This field may return null, indicating that no valid values can be obtained.

      CompareTaskItem

      Information of the data consistency check object

      Used by actions: DescribeCompareTasks.

      Name Type Description
      JobId String Task ID
      Note: This field may return null, indicating that no valid values can be obtained.
      CompareTaskId String Data consistency check task ID
      Note: This field may return null, indicating that no valid values can be obtained.
      TaskName String Data consistency check task name
      Note: This field may return null, indicating that no valid values can be obtained.
      Status String Data consistency check task status. Valid values: created, readyRun, running, success, stopping, failed, canceled.
      Note: This field may return null, indicating that no valid values can be obtained.
      Config CompareObject Data consistency check task configuration
      Note: This field may return null, indicating that no valid values can be obtained.
      CheckProcess ProcessProgress Check details of the data consistency check task
      Note: This field may return null, indicating that no valid values can be obtained.
      CompareProcess ProcessProgress Running details of the data consistency check task
      Note: This field may return null, indicating that no valid values can be obtained.
      Conclusion String Comparison result. Valid values: same, different, skipAll.
      Note: This field may return null, indicating that no valid values can be obtained.
      CreatedAt String Task creation time
      Note: This field may return null, indicating that no valid values can be obtained.
      StartedAt String Task start time
      Note: This field may return null, indicating that no valid values can be obtained.
      FinishedAt String Comparison end time
      Note: This field may return null, indicating that no valid values can be obtained.
      Method String Comparison type: (dataCheck: Full data comparison; sampleDataCheck: Sampling data comparison; rowsCount: Row count comparison)
      Note: This field may return null, indicating that no valid values can be obtained.
      Options CompareOptions Configuration information of the comparison task
      Note: This field may return null, indicating that no valid values can be obtained.
      Message String Consistency check prompt message
      Note: This field may return null, indicating that no valid values can be obtained.

      CompareViewItem

      View configuration for data consistency check

      Used by actions: CreateCompareTask, DescribeCompareReport, DescribeCompareTasks, ModifyCompareTask.

      Name Type Required Description
      ViewName String No View name
      Note: This field may return null, indicating that no valid values can be obtained.

      ConflictHandleOption

      Detailed description of conflict processing

      Used by actions: ConfigureSyncJob, DescribeSyncJobs, ModifySyncJobConfig.

      Name Type Required Description
      ConditionColumn String No Conditionally overwritten column
      Note: This field may return null, indicating that no valid values can be obtained.
      ConditionOperator String No Conditional overwrite operation
      Note: This field may return null, indicating that no valid values can be obtained.
      ConditionOrderInSrcAndDst String No Conditional overwrite priority configuration
      Note: This field may return null, indicating that no valid values can be obtained.

      ConsistencyOption

      Data consistency check option. Data consistency check is disabled by default.

      Used by actions: DescribeMigrationDetail, ModifyMigrationJob.

      Name Type Required Description
      Mode String No Data consistency check type. Valid values: full, noCheck, notConfigured.
      Note: This field may return null, indicating that no valid values can be obtained.

      DBEndpointInfo

      Instance information

      Used by actions: DescribeMigrationDetail, DescribeMigrationJobs, ModifyMigrationJob.

      Name Type Required Description
      Region String Yes Instance region
      Note: This field may return null, indicating that no valid values can be obtained.
      AccessType String Yes Instances network access type. Valid values: extranet (public network); ipv6 (public IPv6); cvm (self-build on CVM); dcg (Direct Connect); vpncloud (VPN access); cdb (database); ccn (CCN); intranet (intranet); vpc (VPC). Note that the valid values are subject to the current link.
      Note: This field may return null, indicating that no valid values can be obtained.
      DatabaseType String Yes Database type, such as mysql, redis, mongodb, postgresql, mariadb, and percona.
      Note: This field may return null, indicating that no valid values can be obtained.
      NodeType String Yes Node type, empty or simple indicates a general node, cluster indicates a cluster node; for mongo services, valid values: replicaset (mongodb replica set), standalone (mongodb single node), cluster (mongodb cluster); for redis instances, valid values: empty or simple (single node), cluster (cluster), cluster-cache (cache cluster), cluster-proxy (proxy cluster).Note: This field may return null, indicating that no valid values can be obtained.
      Info Array of DBInfo Yes Database information
      Note: This field may return null, indicating that no valid values can be obtained.
      Supplier String No Instance service provider, such as "aliyun" and "others".
      Note: This field may return null, indicating that no valid values can be obtained.
      ExtraAttr Array of KeyValuePairOption No For MongoDB, you can define the following parameters: ['AuthDatabase':'admin',
      'AuthFlag': "1", 'AuthMechanism':"SCRAM-SHA-1"]
      Note: This field may return null, indicating that no valid values can be obtained.
      DatabaseNetEnv String No Network environment of the database. This parameter is required when AccessType is ccn. Valid values: UserIDC (user IDC), TencentVPC (Tencent Cloud VPC).
      Note: This field may return null, indicating that no valid values can be obtained.
      ConnectType String No

      DBInfo

      Database information

      Used by actions: DescribeMigrationDetail, DescribeMigrationJobs, ModifyMigrationJob.

      Name Type Required Description
      Role String No Node role in a distributed database, such as the mongos node in MongoDB.
      Note: This field may return null, indicating that no valid values can be obtained.
      DbKernel String No Kernel version, such as the different kernel versions of MariaDB.
      Note: This field may return null, indicating that no valid values can be obtained.
      Host String No Instance IP address, which is required for the following access types: public network, Direct Connect, VPN, CCN, intranet, and VPC.
      Note: This field may return null, indicating that no valid values can be obtained.
      Port Integer No Instance port, which is required for the following access types: public network, self-build on CVM, Direct Connect, VPN, CCN, intranet, and VPC.
      Note: This field may return null, indicating that no valid values can be obtained.
      User String No Instance username
      Note: This field may return null, indicating that no valid values can be obtained.
      Password String No Instance password
      Note: This field may return null, indicating that no valid values can be obtained.
      CvmInstanceId String No Short CVM instance ID in the format of ins-olgl39y8, which is required if the access type is cvm. It is the same as the instance ID displayed in the CVM console.
      Note: This field may return null, indicating that no valid values can be obtained.
      UniqVpnGwId String No VPN gateway ID in the format of vpngw-9ghexg7q, which is required if the access type is vpncloud.
      Note: This field may return null, indicating that no valid values can be obtained.
      UniqDcgId String No Direct Connect gateway ID in the format of dcg-0rxtqqxb, which is required if the access type is dcg.
      Note: This field may return null, indicating that no valid values can be obtained.
      InstanceId String No Database instance ID in the format of cdb-powiqx8q, which is required if the access type is cdb.
      Note: This field may return null, indicating that no valid values can be obtained.
      CcnGwId String No CCN instance ID such as ccn-afp6kltc
      Note: This field may return null, indicating that no valid values can be obtained.
      VpcId String No VPC ID in the format of vpc-92jblxto, which is required if the access type is vpc, vpncloud, ccn, or dcg.
      Note: This field may return null, indicating that no valid values can be obtained.
      SubnetId String No ID of the subnet in the VPC in the format of subnet-3paxmkdz, which is required if the access type is vpc, vpncloud, ccn, or dcg.
      Note: This field may return null, indicating that no valid values can be obtained.
      EngineVersion String No Database version in the format of 5.6 or 5.7, which takes effect only if the instance is an RDS instance. Default value: 5.6.
      Note: This field may return null, indicating that no valid values can be obtained.
      Account String No Instance account
      Note: This field may return null, indicating that no valid values can be obtained.
      AccountRole String No The role used for cross-account migration, which can contain [a-zA-Z0-9-_]+.
      Note: This field may return null, indicating that no valid values can be obtained.
      AccountMode String No The account to which the resource belongs. Valid values: empty or self (the current account); other (another account).
      Note: This field may return null, indicating that no valid values can be obtained.
      TmpSecretId String No Temporary SecretId, you can obtain the temporary key by GetFederationToken.Note: This field may return null, indicating that no valid values can be obtained.
      TmpSecretKey String No Temporary SecretKey, you can obtain the temporary key by GetFederationToken.Note: This field may return null, indicating that no valid values can be obtained.
      TmpToken String No Temporary token, you can obtain the temporary key by GetFederationToken.Note: This field may return null, indicating that no valid values can be obtained.

      DBItem

      Migration object information, which is case-sensitive when objects such as databases, tables, and views are configured.

      Used by actions: DescribeMigrationDetail, ModifyMigrationJob.

      Name Type Required Description
      DbName String No Name of the database to be migrated or synced, which is required if ObjectMode is partial.
      Note: This field may return null, indicating that no valid values can be obtained.
      NewDbName String No Name of the database after migration or sync, which is the same as the source database name by default.
      Note: This field may return null, indicating that no valid values can be obtained.
      SchemaName String No The schema to be migrated or synced
      Note: This field may return null, indicating that no valid values can be obtained.
      NewSchemaName String No Name of the schema after migration or sync
      Note: This field may return null, indicating that no valid values can be obtained.
      DBMode String No Database selection mode, which is required if ObjectMode is partial. Valid values: all, partial.
      Note: This field may return null, indicating that no valid values can be obtained.
      SchemaMode String No Schema selection mode. Valid values: all, partial.
      Note: This field may return null, indicating that no valid values can be obtained.
      TableMode String No Table selection mode, which is required if DBMode is partial. Valid values: all, partial.
      Note: This field may return null, indicating that no valid values can be obtained.
      Tables Array of TableItem No The set of table objects, which is required if TableMode is partial.
      Note: This field may return null, indicating that no valid values can be obtained.
      ViewMode String No View selection mode. Valid values: all, partial.
      Note: This field may return null, indicating that no valid values can be obtained.
      Views Array of ViewItem No The set of view objects, which is required if ViewMode is partial.
      Note: This field may return null, indicating that no valid values can be obtained.
      RoleMode String No Role selection mode, which is exclusive to PostgreSQL. Valid values: all, partial.
      Note: This field may return null, indicating that no valid values can be obtained.
      Roles Array of RoleItem No Role, which is exclusive to PostgreSQL and required if RoleMode is partial.
      Note: This field may return null, indicating that no valid values can be obtained.
      FunctionMode String No Sync mode. Valid values: partial, all.
      Note: This field may return null, indicating that no valid values can be obtained.
      TriggerMode String No Sync mode. Valid values: partial, all.
      Note: This field may return null, indicating that no valid values can be obtained.
      EventMode String No Sync mode. Valid values: partial, all.
      Note: This field may return null, indicating that no valid values can be obtained.
      ProcedureMode String No Sync mode. Valid values: partial, all.
      Note: This field may return null, indicating that no valid values can be obtained.
      Functions Array of String No This parameter is required if FunctionMode is partial.
      Note: This field may return null, indicating that no valid values can be obtained.
      Procedures Array of String No This parameter is required if ProcedureMode is partial.
      Note: This field may return null, indicating that no valid values can be obtained.
      Events Array of String No This parameter is required if EventMode is partial.
      Note: This field may return null, indicating that no valid values can be obtained.
      Triggers Array of String No This parameter is required if TriggerMode is partial.
      Note: This field may return null, indicating that no valid values can be obtained.

      Database

      The database/table objects to be synced

      Used by actions: ConfigureSyncJob, DescribeSyncJobs, ModifySyncJobConfig.

      Name Type Required Description
      DbName String No Name of the database to be migrated or synced, which is required if ObjectMode is Partial.
      Note: This field may return null, indicating that no valid values can be obtained.
      NewDbName String No Name of the database after migration or sync, which is the same as the source database name by default.
      Note: This field may return null, indicating that no valid values can be obtained.
      DbMode String No Database selection mode, which is required if Mode is Partial. Valid values: All, Partial. Note that the sync of advanced objects does not depend on this parameter. To sync an entire database, set this parameter to All.
      Note: This field may return null, indicating that no valid values can be obtained.
      SchemaName String No The schema to be migrated or synced
      Note: This field may return null, indicating that no valid values can be obtained.
      NewSchemaName String No Name of the schema after migration or sync
      Note: This field may return null, indicating that no valid values can be obtained.
      TableMode String No Table selection mode, which is required if DBMode is Partial. Valid values: All, Partial. To sync an entire database, set this parameter to All.
      Note: This field may return null, indicating that no valid values can be obtained.
      Tables Array of Table No The set of table objects, which is required if TableMode is Partial.
      Note: This field may return null, indicating that no valid values can be obtained.
      ViewMode String No View selection mode. Valid values: All, Partial. To sync an entire database, set this parameter to All.
      Note: This field may return null, indicating that no valid values can be obtained.
      Views Array of View No The set of view objects, which is required if ViewMode is Partial.
      Note: This field may return null, indicating that no valid values can be obtained.
      FunctionMode String No Sync mode. Valid values: All, Partial. To sync an entire database, set this parameter to All.
      Note: This field may return null, indicating that no valid values can be obtained.
      Functions Array of String No This parameter is required if FunctionMode is Partial.
      Note: This field may return null, indicating that no valid values can be obtained.
      ProcedureMode String No Sync mode. Valid values: All, Partial. To sync an entire database, set this parameter to All.
      Note: This field may return null, indicating that no valid values can be obtained.
      Procedures Array of String No This parameter is required if ProcedureMode is Partial.
      Note: This field may return null, indicating that no valid values can be obtained.
      TriggerMode String No Trigger sync mode. Valid values: All, Partial. To sync an entire database, set this parameter to All. Currently, the advanced object “trigger” is not supported for data sync.
      Note: This field may return null, indicating that no valid values can be obtained.
      Triggers Array of String No This parameter is used to specify the names of the triggers to be migrated when the value of TriggerMode is partial.
      Note: This field may return null, indicating that no valid values can be obtained.
      EventMode String No Event sync mode. Valid values: All, Partial. To sync an entire database, set this parameter to All. Currently, the advanced object “event” is not supported for data sync.
      Note: This field may return null, indicating that no valid values can be obtained.
      Events Array of String No This parameter is used to specify the names of the events to be migrated when the value of EventMode is partial.
      Note: This field may return null, indicating that no valid values can be obtained.

      DatabaseTableObject

      Migration object options, which tell DTS which database/table objects should be migrated.

      Used by actions: DescribeMigrationDetail, ModifyMigrationJob.

      Name Type Required Description
      ObjectMode String Yes Migration object type. Valid values: all, partial.
      Note: This field may return null, indicating that no valid values can be obtained.
      Databases Array of DBItem No Migration object, which is required if ObjectMode is partial.
      Note: This field may return null, indicating that no valid values can be obtained.
      AdvancedObjects Array of String No Advanced object types, such as trigger, function, procedure, event. Note: If you want to migrate and synchronize advanced objects, the corresponding advanced object type should be included in this configuration.Note: This field may return null, indicating that no valid values can be obtained.

      DdlOption

      DDL statement sync processing during data sync

      Used by actions: ConfigureSyncJob, DescribeSyncJobs, ModifySyncJobConfig.

      Name Type Required Description
      DdlObject String No DDL type, such as database, table, view, and index.
      Note: This field may return null, indicating that no valid values can be obtained.
      DdlValue Array of String No DDL value. Valid values: [Create,Drop,Alter] for database
      [Create,Drop,Alter,Truncate,Rename] for table
      [Create,Drop] for view
      [Create,Drop] for index
      Note: This field may return null, indicating that no valid values can be obtained.

      DetailCheckItem

      Specific check item in this check step

      Used by actions: DescribeMigrationCheckJob.

      Name Type Description
      CheckItemName String Check item name, such as source database permission check.
      Note: This field may return null, indicating that no valid values can be obtained.
      Description String Check item details
      Note: This field may return null, indicating that no valid values can be obtained.
      CheckResult String Check item result. Valid values: pass (pass); failed (failure); warning (pass with warning).
      Note: This field may return null, indicating that no valid values can be obtained.
      FailureReason String The cause of the check item failure
      Note: This field may return null, indicating that no valid values can be obtained.
      Solution String Solution
      Note: This field may return null, indicating that no valid values can be obtained.
      ErrorLog Array of String Execution error log
      Note: This field may return null, indicating that no valid values can be obtained.
      HelpDoc Array of String URL of the detailed help document
      Note: This field may return null, indicating that no valid values can be obtained.
      SkipInfo String Prompt text for ignoring a risk
      Note: This field may return null, indicating that no valid values can be obtained.

      DifferenceDetail

      Details of inconsistent tables

      Used by actions: DescribeCompareReport.

      Name Type Description
      TotalCount Integer Number of inconsistent tables
      Note: This field may return null, indicating that no valid values can be obtained.
      Items Array of DifferenceItem Details of inconsistent tables
      Note: This field may return null, indicating that no valid values can be obtained.

      DifferenceItem

      Details of inconsistent tables

      Used by actions: DescribeCompareReport.

      Name Type Description
      Db String Database name
      Note: This field may return null, indicating that no valid values can be obtained.
      Table String Table name
      Note: This field may return null, indicating that no valid values can be obtained.
      Chunk Integer Chunk ID
      Note: This field may return null, indicating that no valid values can be obtained.
      SrcItem String Source database value
      Note: This field may return null, indicating that no valid values can be obtained.
      DstItem String Target database value
      Note: This field may return null, indicating that no valid values can be obtained.
      IndexName String Index name
      Note: This field may return null, indicating that no valid values can be obtained.
      LowerBoundary String First index key
      Note: This field may return null, indicating that no valid values can be obtained.
      UpperBoundary String Last index key
      Note: This field may return null, indicating that no valid values can be obtained.
      CostTime Float Comparison time in ms
      Note: This field may return null, indicating that no valid values can be obtained.
      FinishedAt String Completion time
      Note: This field may return null, indicating that no valid values can be obtained.

      DynamicOptions

      Data sync options

      Used by actions: ModifySyncJobConfig.

      Name Type Required Description
      OpTypes Array of String Yes DML and DDL options to be synced. Valid values: Insert (INSERT), Update (UPDATE), Delete (DELETE), DDL (structure sync), PartialDDL (custom option, which is used together with DdlOptions). This parameter is required, and its value will overwrite the previous value. Note: This field may return null, indicating that no valid values can be obtained.
      DdlOptions Array of DdlOption Yes DDL options to be synced. This parameter is required when OpTypes is PartialDDL, and its value will overwrite the previous value. Note: This field may return null, indicating that no valid values can be obtained.
      ConflictHandleType String No Conflict resolution method. Valid values: ReportError (Report error), Ignore (Ignore), Cover (Overwrite), ConditionCover (Conditionally overwrite). Currently, this parameter cannot be modified if the target of the link is Kafka. Note: This field may return null, indicating that no valid values can be obtained.
      ConflictHandleOption ConflictHandleOption No Detailed options of the conflict resolution method, such as the conditionally overwritten rows and condition operations for the “conditionally overwrite” method. The internal field of this parameter cannot be modified separately. If this parameter needs to be updated, update it fully. Note: This field may return null, indicating that no valid values can be obtained.

      Endpoint

      Information of the source and target databases in data sync

      Used by actions: ConfigureSyncJob, DescribeSyncJobs.

      Name Type Required Description
      Region String No Region name, such as ap-guangzhou.
      Note: This field may return null, indicating that no valid values can be obtained.
      Role String No Node type of TDSQL for MySQL. Enumerated values: proxy, set.
      Note: This field may return null, indicating that no valid values can be obtained.
      DbKernel String No Database kernel type, which is used to distinguish between different kernels in TDSQL. Valid values: percona, mariadb, mysql.
      Note: This field may return null, indicating that no valid values can be obtained.
      InstanceId String No Database instance ID in the format of cdb-powiqx8q
      Note: This field may return null, indicating that no valid values can be obtained.
      Ip String No Instance IP address, which is required if the access type is not cdb.
      Note: This field may return null, indicating that no valid values can be obtained.
      Port Integer No Instance port, which is required if the access type is not cdb.
      Note: This field may return null, indicating that no valid values can be obtained.
      User String No Username, which is required for an instance authenticated by username and password.
      Note: This field may return null, indicating that no valid values can be obtained.
      Password String No Password, which is required for an instance authenticated by username and password.
      Note: This field may return null, indicating that no valid values can be obtained.
      DbName String No Database name, which is required if the database type is cdwpg.
      Note: This field may return null, indicating that no valid values can be obtained.
      VpcId String No VPC ID in the format of vpc-92jblxto, which is required if the access type is vpc, dcg, or vpncloud.
      Note: This field may return null, indicating that no valid values can be obtained.
      SubnetId String No ID of the subnet in the VPC in the format of subnet-3paxmkdz, which is required if the access type is vpc, dcg, or vpncloud.
      Note: This field may return null, indicating that no valid values can be obtained.
      CvmInstanceId String No Short CVM instance ID in the format of ins-olgl39y8, which is required if the access type is cvm. It is the same as the instance ID displayed in the CVM console.
      Note: This field may return null, indicating that no valid values can be obtained.
      UniqDcgId String No Direct Connect gateway ID in the format of dcg-0rxtqqxb, which is required if the access type is dcg.
      Note: This field may return null, indicating that no valid values can be obtained.
      UniqVpnGwId String No VPN gateway ID in the format of vpngw-9ghexg7q, which is required if the access type is vpncloud.
      Note: This field may return null, indicating that no valid values can be obtained.
      CcnId String No CCN instance ID in the format of ccn-afp6kltc, which is required if the access type is ccn.
      Note: This field may return null, indicating that no valid values can be obtained.
      Supplier String No Cloud vendor type. For Alibaba Cloud ApsaraDB for RDS instances, enter aliyun; otherwise, enter others. Default value: others.
      Note: This field may return null, indicating that no valid values can be obtained.
      EngineVersion String No Database version in the format of 5.6 or 5.7, which takes effect only if the instance is an RDS instance. Default value: 5.6.
      Note: This field may return null, indicating that no valid values can be obtained.
      Account String No Instance account, which is required if the operation is performed across accounts.
      Note: This field may return null, indicating that no valid values can be obtained.
      AccountMode String No The account to which the resource belongs. Valid values: empty or self (the current account); other (another account).
      Note: This field may return null, indicating that no valid values can be obtained.
      AccountRole String No The role used for cross-account sync, which can contain [a-zA-Z0-9-_]+ and is required if the operation is performed across accounts.
      Note: This field may return null, indicating that no valid values can be obtained.
      RoleExternalId String No External role ID
      Note: This field may return null, indicating that no valid values can be obtained.
      TmpSecretId String No Temporary SecretId, you can obtain the temporary key by GetFederationToken. This field is required if it is a cross-account instance.Note: This field may return null, indicating that no valid values can be obtained.
      TmpSecretKey String No Temporary SecretKey, you can obtain the temporary key by GetFederationToken. This field is required if it is a cross-account instance.Note: This field may return null, indicating that no valid values can be obtained.
      TmpToken String No Temporary token, you can obtain the temporary key by GetFederationToken. This field is required if it is a cross-account instance. Note: This field may return null, indicating that no valid values can be obtained.
      EncryptConn String No Whether to enable encrypted transfer (UnEncrypted: No; Encrypted: Yes). Default value: UnEncrypted.
      Note: This field may return null, indicating that no valid values can be obtained.
      DatabaseNetEnv String No Network environment of the database. This parameter is required when AccessType is ccn. Valid values: UserIDC (user IDC), TencentVPC (Tencent Cloud VPC).
      Note: This field may return null, indicating that no valid values can be obtained.
      CcnOwnerUin String No The root account of CCN in the scenario where the database is connected to CCN under another Tencent Cloud account
      Note: This field may return null, indicating that no valid values can be obtained.
      ChildInstanceId String No
      ChildInstanceType String No
      SetId String No

      ErrInfo

      Error information and the corresponding solution

      Used by actions: DescribeSyncJobs.

      Name Type Description
      Reason String Cause of the error
      Message String Error message
      Note: This field may return null, indicating that no valid values can be obtained.
      Solution String Solution
      Note: This field may return null, indicating that no valid values can be obtained.

      ErrorInfoItem

      Task error information

      Used by actions: DescribeMigrationDetail.

      Name Type Description
      Code String Error code
      Note: This field may return null, indicating that no valid values can be obtained.
      Solution String Solution
      Note: This field may return null, indicating that no valid values can be obtained.
      ErrorLog String Error log
      Note: This field may return null, indicating that no valid values can be obtained.
      HelpDoc String Help document
      Note: This field may return null, indicating that no valid values can be obtained.

      JobItem

      Migration task list

      Used by actions: DescribeMigrationJobs.

      Name Type Description
      JobId String Data migration task ID
      Note: This field may return null, indicating that no valid values can be obtained.
      JobName String Data migration task name
      Note: This field may return null, indicating that no valid values can be obtained.
      CreateTime String Task creation (submission) time in the format of yyyy-mm-dd hh:mm:ss
      Note: This field may return null, indicating that no valid values can be obtained.
      UpdateTime String Task update time in the format of yyyy-mm-dd hh:mm:ss
      Note: This field may return null, indicating that no valid values can be obtained.
      StartTime String Task start time in the format of yyyy-mm-dd hh:mm:ss
      Note: This field may return null, indicating that no valid values can be obtained.
      EndTime String Task end time in the format of yyyy-mm-dd hh:mm:ss
      Note: This field may return null, indicating that no valid values can be obtained.
      BriefMsg String Migration task error message
      Note: This field may return null, indicating that no valid values can be obtained.
      Status String Task status. Valid values: creating (Creating), created(Created), checking (Checking), checkPass (Check passed), checkNotPass (Check not passed), readyRun (Ready for running), running (Running), readyComplete (Preparation completed), success (Successful), failed (Failed), stopping (Stopping), completing (Completing), pausing (Pausing), manualPaused (Paused). Note: This field may return null, indicating that no valid values can be obtained.
      RunMode String Task running mode. Valid values: immediate, timed.
      Note: This field may return null, indicating that no valid values can be obtained.
      ExpectRunTime String Expected start time in the format of "2022-07-11 16:20:49", which is required if RunMode is timed.
      Note: This field may return null, indicating that no valid values can be obtained.
      Action MigrateAction Task operation information
      Note: This field may return null, indicating that no valid values can be obtained.
      StepInfo MigrateDetailInfo Information of the migration task execution process
      Note: This field may return null, indicating that no valid values can be obtained.
      SrcInfo DBEndpointInfo Source instance information
      Note: This field may return null, indicating that no valid values can be obtained.
      DstInfo DBEndpointInfo Target database information
      Note: This field may return null, indicating that no valid values can be obtained.
      CompareTask CompareTaskInfo Data consistency check result
      Note: This field may return null, indicating that no valid values can be obtained.
      TradeInfo TradeInfo Billing status information
      Note: This field may return null, indicating that no valid values can be obtained.
      Tags Array of TagItem Tag information
      Note: This field may return null, indicating that no valid values can be obtained.
      AutoRetryTimeRangeMinutes Integer Information of automatic retry time
      Note: This field may return null, indicating that no valid values can be obtained.
      DumperResumeCtrl String Whether the task can be reentered in the full export stage. Valid values: yes, no. yes: The current task can be reentered. no: The current task is in the full export stage which cannot be reentered. If the value of this parameter is no, the checkpoint restart is not supported when the task is restarted in the export stage.
      Note: This field may return null, indicating that no valid values can be obtained.

      KafkaOption

      Sync options configured when the target database is Kafka

      Used by actions: ConfigureSyncJob, DescribeSyncJobs.

      Name Type Required Description
      DataType String No Data type delivered to Kafka, such as Avro, Json, canal-pb, canal-json
      TopicType String No Topic sync policy, such as Single (deliver all data to a single topic), Multi (deliver data to multiple custom topics).
      DDLTopicName String No Topic for DDL storage
      TopicRules Array of TopicRule No Topic description

      KeyValuePairOption

      Additional configuration information

      Used by actions: DescribeMigrationDetail, DescribeMigrationJobs, ModifyMigrationJob.

      Name Type Required Description
      Key String No Option key
      Note: This field may return null, indicating that no valid values can be obtained.
      Value String No Option value
      Note: This field may return null, indicating that no valid values can be obtained.

      MigrateAction

      Task operation information, which contains the list of all operations in the migration task as well as the list of allowed operations under the current status.

      Used by actions: DescribeMigrationDetail, DescribeMigrationJobs.

      Name Type Description
      AllAction Array of String List of all operations in the task
      Note: This field may return null, indicating that no valid values can be obtained.
      AllowedAction Array of String List of allowed operations in the task under the current status
      Note: This field may return null, indicating that no valid values can be obtained.

      MigrateDBItem

      Object in the migration task instance list

      Used by actions: DescribeMigrateDBInstances.

      Name Type Description
      InstanceId String Instance ID
      InstanceName String Instance name
      Vip String Instance VIP
      Vport Integer Instance Vport
      Usable Integer Whether the instance can be migrated. Valid values: 1 (yes); 0` (no).
      Hint String The cause why the instance cannot be migrated

      MigrateDetailInfo

      Information of the migration task execution process

      Used by actions: DescribeMigrationDetail, DescribeMigrationJobs.

      Name Type Description
      StepAll Integer Total number of steps
      Note: This field may return null, indicating that no valid values can be obtained.
      StepNow Integer Current step
      Note: This field may return null, indicating that no valid values can be obtained.
      MasterSlaveDistance Integer Source-replica lag in MB. This parameter takes effect only when the task is normal and is in the last step of migration or sync (binlog sync). If it is invalid, -1 will be returned.
      Note: This field may return null, indicating that no valid values can be obtained.
      SecondsBehindMaster Integer Source-replica lag in seconds. This parameter takes effect only when the task is normal and is in the last step of migration or sync (binlog sync). If it is invalid, -1 will be returned.
      Note: This field may return null, indicating that no valid values can be obtained.
      StepInfo Array of StepDetailInfo Step information
      Note: This field may return null, indicating that no valid values can be obtained.

      MigrateOption

      Migration options, which describe how the task performs migration.

      Used by actions: DescribeMigrationDetail, ModifyMigrationJob.

      Name Type Required Description
      DatabaseTable DatabaseTableObject Yes Migration object options, which tell DTS which database/table objects should be migrated.
      Note: This field may return null, indicating that no valid values can be obtained.
      MigrateType String No Migration type. Valid values: full, structure, fullAndIncrement. Default value: fullAndIncrement.
      Note: This field may return null, indicating that no valid values can be obtained.
      Consistency ConsistencyOption No Data consistency check option. Data consistency check is disabled by default.
      Note: This field may return null, indicating that no valid values can be obtained.
      IsMigrateAccount Boolean No Whether to migrate accounts. Valid values: yes, no.
      Note: This field may return null, indicating that no valid values can be obtained.
      IsOverrideRoot Boolean No Whether to use the Root account in the source database to overwrite that in the target database. Valid values: false, true. For database/table or structural migration, you should specify false. Note that this parameter takes effect only for OldDTS.
      Note: This field may return null, indicating that no valid values can be obtained.
      IsDstReadOnly Boolean No Whether to set the target database to read-only during migration, which takes effect only for MySQL databases. Valid values: true, false. Default value: false.
      Note: This field may return null, indicating that no valid values can be obtained.
      ExtraAttr Array of KeyValuePairOption No Additional information. You can set additional parameters for certain database types. For Redis, you can define the following parameters:
      ["DstWriteMode": normal. Target database write mode. Valid values: clearData (Clear the target instance data), overwrite(Execute the task in overwriting mode),normal(Follow the normal steps) "IsDstReadOnly":true. Whether to set the target database to read-only for a migration task. Valid values: true(Yes),false` (No) "ClientOutputBufferHardLimit": 512. Hard limit of the replica buffer zone capacity in MB. "ClientOutputBufferSoftLimit": 512. Soft limit of the replica buffer zone capacity in MB. "ClientOutputBufferPersistTime": 60. Soft limit duration of the replica buffer zone in seconds. "ReplBacklogSize": 512, Limit of the circular buffer zone capacity in MB. "ReplTimeout":120, Replication timeout period in seconds]
      Note: This field may return null, indicating that no valid values can be obtained.
      MigrateWay String No

      Objects

      Description of synced database objects

      Used by actions: ConfigureSyncJob, DescribeSyncJobs, ModifySyncJobConfig.

      Name Type Required Description
      Mode String No Sync object type. Valid value: Partial (Partial objects). Note: This field may return null, indicating that no valid values can be obtained.
      Databases Array of Database No Sync object, which is required if Mode is Partial.
      Note: This field may return null, indicating that no valid values can be obtained.
      AdvancedObjects Array of String No Advanced object types, such as function and procedure. Note: If you want to migrate and synchronize advanced objects, the corresponding advanced object type should be included in this configuration. When advanced objects need to be synchronized, the initialization type must include the structure initialization type, that is, the Options.InitType value of the task is Structure or Full.Note: This field may return null, indicating that no valid values can be obtained.
      OnlineDDL OnlineDDL No A redundant field that specifies the online DDL type
      Note: This field may return null, indicating that no valid values can be obtained.

      OnlineDDL

      Online DDL type

      Used by actions: ConfigureSyncJob, DescribeSyncJobs, ModifySyncJobConfig.

      Name Type Required Description
      Status String Yes Status
      Note: This field may return null, indicating that no valid values can be obtained.

      Options

      Data sync options

      Used by actions: ConfigureSyncJob, DescribeSyncJobs.

      Name Type Required Description
      InitType String No Sync initialization option. Valid values: data (full data initialization); Structure (structure initialization); Full (full data and structure initialization); None (incremental data only). Default value: Full.
      Note: This field may return null, indicating that no valid values can be obtained.
      DealOfExistSameTable String No Processing method for duplicate tables. Valid values: ReportErrorAfterCheck, InitializeAfterDelete, ExecuteAfterIgnore. Default value: ReportErrorAfterCheck.
      Note: This field may return null, indicating that no valid values can be obtained.
      ConflictHandleType String No Conflict processing option. Valid values: ReportError (report an error); Ignore (ignore); Cover (overwrite); ConditionCover (conditionally overwrite). Default value: ReportError.
      Note: This field may return null, indicating that no valid values can be obtained.
      AddAdditionalColumn Boolean No Whether to add the additional column
      Note: This field may return null, indicating that no valid values can be obtained.
      OpTypes Array of String No DML and DDL options to be synced. Valid values: Insert (INSERT operations); Update (UPDATE operations); Delete (DELETE operations); DDL (structure sync); PartialDDL (custom option, which is used together with DdlOptions). You can also leave this parameter empty.
      Note: This field may return null, indicating that no valid values can be obtained.
      ConflictHandleOption ConflictHandleOption No Detailed option for conflict processing, such as condition rows and operations in conditional overwrite.
      Note: This field may return null, indicating that no valid values can be obtained.
      DdlOptions Array of DdlOption No DDL statements to be synced
      Note: This field may return null, indicating that no valid values can be obtained.
      KafkaOption KafkaOption No Kafka sync options
      Note: This field may return null, indicating that no valid values can be obtained.
      RateLimitOption RateLimitOption No Task speed limit information
      Note: This field may return null, indicating that no valid values can be obtained.
      AutoRetryTimeRangeMinutes Integer No Settings of the automatic retry time range
      Note: This field may return null, indicating that no valid values can be obtained.
      FilterBeginCommit Boolean No
      FilterCheckpoint Boolean No

      ProcessProgress

      Task step information

      Used by actions: DescribeCompareTasks, DescribeMigrationDetail.

      Name Type Description
      Status String Step status. Valid values: notStarted, running, success, failed.
      Note: This field may return null, indicating that no valid values can be obtained.
      Percent Integer Progress information
      Note: This field may return null, indicating that no valid values can be obtained.
      StepAll Integer Total number of steps
      Note: This field may return null, indicating that no valid values can be obtained.
      StepNow Integer Current step
      Note: This field may return null, indicating that no valid values can be obtained.
      Message String The prompt output in the current step
      Note: This field may return null, indicating that no valid values can be obtained.
      Steps Array of StepDetailInfo Step information
      Note: This field may return null, indicating that no valid values can be obtained.

      ProcessStepTip

      Object of the error or warning information

      Used by actions: DescribeCompareTasks, DescribeMigrationDetail, DescribeMigrationJobs.

      Name Type Description
      Message String Prompt message
      Note: This field may return null, indicating that no valid values can be obtained.
      Solution String Solution
      Note: This field may return null, indicating that no valid values can be obtained.
      HelpDoc String Help document
      Note: This field may return null, indicating that no valid values can be obtained.

      RateLimitOption

      Speed limit details of migration and sync tasks

      Used by actions: ConfigureSyncJob, DescribeMigrationDetail, DescribeSyncJobs.

      Name Type Required Description
      CurrentDumpThread Integer Yes The number of full export threads currently in effect. The value of this field can be adjusted when configuring the task. Note: If it is not set or set to 0, it means the current value is maintained. The maximum value is 16.Note: This field may return null, indicating that no valid values can be obtained.
      DefaultDumpThread Integer Yes The default number of full export threads. This field is only meaningful in the output parameter.Note: This field may return null, indicating that no valid values can be obtained.
      CurrentDumpRps Integer Yes The full export Rps currently in effect. The value of this field can be adjusted when configuring the task. Note: If it is not set or set to 0, it means the current value is maintained. The maximum value is 50,000,000.Note: This field may return null, indicating that no valid values can be obtained.
      DefaultDumpRps Integer Yes The default full export Rps. This field is only meaningful in the output parameter.Note: This field may return null, indicating that no valid values can be obtained.
      CurrentLoadThread Integer Yes The number of full import threads currently in effect. The value of this field can be adjusted when configuring the task. Note: If it is not set or set to 0, it means the current value is maintained. The maximum value is 16.Note: This field may return null, indicating that no valid values can be obtained.
      DefaultLoadThread Integer Yes The default number of full import threads. This field is only meaningful in the output parameter.Note: This field may return null, indicating that no valid values can be obtained.
      CurrentLoadRps Integer Yes The full import Rps currently in effect. The value of this field can be adjusted when configuring the task. Note: If it is not set or set to 0, it means the current value is maintained. The maximum value is 50,000,000.Note: This field may return null, indicating that no valid values can be obtained.
      DefaultLoadRps Integer Yes The default full import Rps. This field is only meaningful in the output parameter.Note: This field may return null, indicating that no valid values can be obtained.
      CurrentSinkerThread Integer Yes The number of incremental import threads currently in effect. The value of this field can be adjusted when configuring the task. Note: If it is not set or set to 0, it means the current value is maintained. The maximum value is 128.Note: This field may return null, indicating that no valid values can be obtained.
      DefaultSinkerThread Integer Yes The default number of incremental import threads. This field is only meaningful in the output parameter.
      Note: This field may return null, indicating that no valid values can be obtained.
      HasUserSetRateLimit String Yes enum:"no"/"yes", no: the user has not set a speed limit; yes: a speed limit has been set. This field is only meaningful in the output parameter.Note: This field may return null, indicating that no valid values can be obtained.

      RoleItem

      Role object, which is exclusive to PostgreSQL.

      Used by actions: DescribeMigrationDetail, ModifyMigrationJob.

      Name Type Required Description
      RoleName String No Role name
      Note: This field may return null, indicating that no valid values can be obtained.
      NewRoleName String No Role name after migration
      Note: This field may return null, indicating that no valid values can be obtained.

      SkippedDetail

      Details of skipped tables

      Used by actions: DescribeCompareReport.

      Name Type Description
      TotalCount Integer Number of skipped tables
      Note: This field may return null, indicating that no valid values can be obtained.
      Items Array of SkippedItem Details of skipped tables
      Note: This field may return null, indicating that no valid values can be obtained.

      SkippedItem

      Details of skipped tables

      Used by actions: DescribeCompareReport.

      Name Type Description
      Db String Database name
      Note: This field may return null, indicating that no valid values can be obtained.
      Table String Table name
      Note: This field may return null, indicating that no valid values can be obtained.
      Reason String The cause why check is not initiated
      Note: This field may return null, indicating that no valid values can be obtained.

      StepDetailInfo

      Step information

      Used by actions: DescribeCompareTasks, DescribeMigrationDetail, DescribeMigrationJobs.

      Name Type Description
      StepNo Integer Step number
      Note: This field may return null, indicating that no valid values can be obtained.
      StepName String Step name
      Note: This field may return null, indicating that no valid values can be obtained.
      StepId String Step ID
      Note: This field may return null, indicating that no valid values can be obtained.
      Status String Step status. Valid values: success, failed, running, notStarted. Default value: notStarted.
      Note: This field may return null, indicating that no valid values can be obtained.
      StartTime String Start time of the current step in the format of "yyyy-mm-dd hh:mm:ss". If this field does not exist or is empty, it is meaningless.
      Note: This field may return null, indicating that no valid values can be obtained.
      StepMessage String Step error message
      Note: This field may return null, indicating that no valid values can be obtained.
      Percent Integer Execution progress
      Note: This field may return null, indicating that no valid values can be obtained.
      Errors Array of ProcessStepTip Error message
      Note: This field may return null, indicating that no valid values can be obtained.
      Warnings Array of ProcessStepTip Warning
      Note: This field may return null, indicating that no valid values can be obtained.

      StepInfo

      Step details

      Used by actions: DescribeCheckSyncJobResult, DescribeModifyCheckSyncJobResult, DescribeSyncJobs.

      Name Type Required Description
      StepNo Integer No Step number
      Note: This field may return null, indicating that no valid values can be obtained.
      StepName String No Step name
      Note: This field may return null, indicating that no valid values can be obtained.
      StepId String No Step ID
      Note: This field may return null, indicating that no valid values can be obtained.
      Status String No Status of the current step. Valid values: notStarted, running, failed, finished, skipped, paused`.
      Note: This field may return null, indicating that no valid values can be obtained.
      StartTime String No Step start time, which may be null.
      Note: This field may return null, indicating that no valid values can be obtained.
      Errors Array of StepTip No Error message
      Note: This field may return null, indicating that no valid values can be obtained.
      Warnings Array of StepTip No Warning message
      Note: This field may return null, indicating that no valid values can be obtained.
      Progress Integer No Current step progress. Value range: 0-100. The value -1 indicates that the progress of the current step is unavailable. Note: This field may return null, indicating that no valid values can be obtained.

      StepTip

      Error or warning information in the current step

      Used by actions: DescribeCheckSyncJobResult, DescribeModifyCheckSyncJobResult.

      Name Type Required Description
      Code String No Error code
      Note: This field may return null, indicating that no valid values can be obtained.
      Message String No Error message
      Note: This field may return null, indicating that no valid values can be obtained.
      Solution String No Solution
      Note: This field may return null, indicating that no valid values can be obtained.
      HelpDoc String No Help document
      Note: This field may return null, indicating that no valid values can be obtained.
      SkipInfo String No Whether the current step is skipped
      Note: This field may return null, indicating that no valid values can be obtained.

      SyncDBEndpointInfos

      Node information of multi-node databases configured for data sync. This data structure is valid for multi-node databases such as TDSQL for MySQL. For single-node databases such as MySQL, use Endpoint instead.

      Used by actions: ConfigureSyncJob, DescribeSyncJobs.

      Name Type Required Description
      Region String Yes Region of the database
      Note: This field may return null, indicating that no valid values can be obtained.
      AccessType String Yes Instance network access type. Valid values: extranet (public network); ipv6 (public IPv6); cvm (self-build on CVM); dcg (Direct Connect); vpncloud (VPN access); cdb (database); ccn (CCN); intranet (intranet); vpc (VPC). Note that the valid values are subject to the current link.
      Note: This field may return null, indicating that no valid values can be obtained.
      DatabaseType String Yes Database type, such as mysql, redis, mongodb, postgresql, mariadb, and percona.
      Note: This field may return null, indicating that no valid values can be obtained.
      Info Array of Endpoint Yes Database information. Note: If the data type is tdsqlmysql, the order of this Endpoint array should correspond to the set order, and the first shard (shardkey range starting from 0) must be entered first.Note: This field may return null, indicating that no valid values can be obtained.

      SyncDetailInfo

      Step information of the sync task

      Used by actions: DescribeSyncJobs.

      Name Type Description
      StepAll Integer Total number of steps
      Note: This field may return null, indicating that no valid values can be obtained.
      StepNow Integer Current step
      Note: This field may return null, indicating that no valid values can be obtained.
      Progress Integer Overall progress
      Note: This field may return null, indicating that no valid values can be obtained.
      CurrentStepProgress Integer Progress of the current step. Value range: 0-100. The value of -1 indicates that you can't check the progress of the current step.
      Note: This field may return null, indicating that no valid values can be obtained.
      MasterSlaveDistance Integer Data volume difference between the sync source and target
      Note: This field may return null, indicating that no valid values can be obtained.
      SecondsBehindMaster Integer Time difference between the sync source and target
      Note: This field may return null, indicating that no valid values can be obtained.
      Message String Overall description
      Note: This field may return null, indicating that no valid values can be obtained.
      StepInfos Array of StepInfo Step details
      Note: This field may return null, indicating that no valid values can be obtained.
      CauseOfCompareDisable String Cause of the failure of initiating data consistency check
      Note: This field may return null, indicating that no valid values can be obtained.
      ErrInfo ErrInfo Task error and the corresponding solution
      Note: This field may return null, indicating that no valid values can be obtained.

      SyncJobInfo

      Sync task information

      Used by actions: DescribeSyncJobs.

      Name Type Description
      JobId String Sync task ID, such as sync-btso140.
      Note: This field may return null, indicating that no valid values can be obtained.
      JobName String Sync task name
      Note: This field may return null, indicating that no valid values can be obtained.
      PayMode String Billing mode. Valid values: PostPay (pay-as-you-go); PrePay (monthly subscription).
      Note: This field may return null, indicating that no valid values can be obtained.
      RunMode String Running mode. Valid values: Immediate, Timed. Default value: Immediate.
      Note: This field may return null, indicating that no valid values can be obtained.
      ExpectRunTime String Expected execution time in the format of yyyy-mm-dd hh:mm:ss
      Note: This field may return null, indicating that no valid values can be obtained.
      AllActions Array of String All supported operations
      Note: This field may return null, indicating that no valid values can be obtained.
      Actions Array of String Operations that can be performed under the current status
      Note: This field may return null, indicating that no valid values can be obtained.
      Options Options Sync options
      Note: This field may return null, indicating that no valid values can be obtained.
      Objects Objects Sync database/table objects
      Note: This field may return null, indicating that no valid values can be obtained.
      Specification String Task specification
      Note: This field may return null, indicating that no valid values can be obtained.
      ExpireTime String Expiration time in the format of yyyy-mm-dd hh:mm:ss
      Note: This field may return null, indicating that no valid values can be obtained.
      SrcRegion String Source database region, such as ap-guangzhou.
      Note: This field may return null, indicating that no valid values can be obtained.
      SrcDatabaseType String Source database type, such as mysql, cynosdbmysql, tdapg, tdpg, and tdsqlmysql.
      Note: This field may return null, indicating that no valid values can be obtained.
      SrcAccessType String Source database access type. Valid values: cdb (database); cvm (self-build on CVM); vpc (VPC); extranet (public network); vpncloud (VPN access); dcg (Direct Connect); ccn (CCN); intranet (intranet).
      Note: This field may return null, indicating that no valid values can be obtained.
      SrcInfo Endpoint Source database information. This parameter is used by single-node databases.
      Note: This field may return null, indicating that no valid values can be obtained.
      SrcNodeType String Valid values: cluster, single. single: For single-node source databases; cluster: For multi-node source databases.
      Note: This field may return null, indicating that no valid values can be obtained.
      SrcInfos SyncDBEndpointInfos Source database information. This parameter is used for multi-node databases.
      Note: This field may return null, indicating that no valid values can be obtained.
      DstRegion String Target database region, such as ap-guangzhou.
      Note: This field may return null, indicating that no valid values can be obtained.
      DstDatabaseType String Target database type, such as mysql, cynosdbmysql, tdapg, tdpg, and tdsqlmysql.
      Note: This field may return null, indicating that no valid values can be obtained.
      DstAccessType String Target database access type. Valid values: cdb (database); cvm (self-build on CVM); vpc (VPC); extranet (public network); vpncloud (VPN access); dcg (Direct Connect); ccn (CCN); intranet (intranet).
      Note: This field may return null, indicating that no valid values can be obtained.
      DstInfo Endpoint Target database information. This parameter is used by single-node databases.
      Note: This field may return null, indicating that no valid values can be obtained.
      DstNodeType String Valid values: cluster, single. single: For single-node target databases; cluster: For multi-node target databases.
      Note: This field may return null, indicating that no valid values can be obtained.
      DstInfos SyncDBEndpointInfos Target database information. This parameter is used for multi-node databases.
      Note: This field may return null, indicating that no valid values can be obtained.
      CreateTime String Creation time in the format of yyyy-mm-dd hh:mm:ss
      Note: This field may return null, indicating that no valid values can be obtained.
      StartTime String Start time in the format of yyyy-mm-dd hh:mm:ss
      Note: This field may return null, indicating that no valid values can be obtained.
      Status String Task status. Valid values: UnInitialized, Initialized, Checking, CheckPass, CheckNotPass, ReadyRunning, Running, Pausing, Paused, Stopping, Stopped, ResumableErr, Resuming, Failed, Released, Resetting, Unknown.
      Note: This field may return null, indicating that no valid values can be obtained.
      EndTime String End time in the format of yyyy-mm-dd hh:mm:ss
      Note: This field may return null, indicating that no valid values can be obtained.
      Tags Array of TagItem Tag information
      Note: This field may return null, indicating that no valid values can be obtained.
      Detail SyncDetailInfo Step information of the sync task
      Note: This field may return null, indicating that no valid values can be obtained.
      TradeStatus String Billing status. Valid values: Normal, Resizing, Renewing, Isolating, Isolated, Offlining, Offlined, NotBilled, Recovering, PostPay2Prepaying, PrePay2Postpaying.
      Note: This field may return null, indicating that no valid values can be obtained.
      InstanceClass String Sync link specification, such as micro, small, medium, and large.
      Note: This field may return null, indicating that no valid values can be obtained.
      AutoRenew Integer Auto-renewal flag, which takes effect if PayMode is PrePay. Valid values: 1 (auto-renewal enabled); 0 (auto-renewal disabled).
      Note: This field may return null, indicating that no valid values can be obtained.
      OfflineTime String Deletion time in the format of yyyy-mm-dd hh:mm:ss
      Note: This field may return null, indicating that no valid values can be obtained.
      AutoRetryTimeRangeMinutes Integer Settings of automatic retry time
      Note: This field may return null, indicating that no valid values can be obtained.
      DumperResumeCtrl String Whether the task can be reentered in the full export stage. Valid values: yes, no. yes: The current task can be reentered. no: The current task is in the full export stage which cannot be reentered. If the value of this parameter is no, the checkpoint restart is not supported when the task is restarted in the export stage.
      Note: This field may return null, indicating that no valid values can be obtained.

      Table

      Synced table description

      Used by actions: ConfigureSyncJob, DescribeSyncJobs, ModifySyncJobConfig.

      Name Type Required Description
      TableName String No Table name
      Note: This field may return null, indicating that no valid values can be obtained.
      NewTableName String No New table name
      Note: This field may return null, indicating that no valid values can be obtained.
      FilterCondition String No Filter condition
      Note: This field may return null, indicating that no valid values can be obtained.
      ColumnMode String No Whether to synchronize all columns in the table. All: all columns under the current table; Partial (the corresponding field ColumnMode in ModifySyncJobConfig interface does not support Partial at the moment): some columns under the current table, detailed table information is provided by filling the Columns field.Note: This field may return null, indicating that no valid values can be obtained.
      Columns Array of Column No Column information in data sync. This field is required when ColumnMode is set to Partial.Note: This field may return null, indicating that no valid values can be obtained.
      TmpTables Array of String No The temp tables to be synced. This parameter is mutually exclusive with NewTableName. It is valid only when the configured sync objects are table-level ones and TableEditMode is pt. To sync temp tables generated when pt-osc or other tools are used during the sync process, you must configure this parameter first. For example, if you want to perform the pt-osc operation on a table named "t1", configure this parameter as ["_t1_new","_t1_old"]; to perform the gh-ost operation on t1, configure it as ["_t1_ghc","_t1_gho","_t1_del"]. Temp tables generated by pt-osc and gh-ost operations can be configured at the same time.
      Note: This field may return null, indicating that no valid values can be obtained.
      TableEditMode String No Table editing type. Valid values: rename (table mapping); pt (additional table sync).
      Note: This field may return null, indicating that no valid values can be obtained.

      TableItem

      The set of table objects, which is required if TableMode is partial.

      Used by actions: DescribeMigrationDetail, ModifyMigrationJob.

      Name Type Required Description
      TableName String No Name of the migrated table, which is case-sensitive
      Note: This field may return null, indicating that no valid values can be obtained.
      NewTableName String No New name of the migrated table. This parameter is required when TableEditMode is rename. It is mutually exclusive with TmpTables.
      Note: This field may return null, indicating that no valid values can be obtained.
      TmpTables Array of String No The temp tables to be migrated. This parameter is mutually exclusive with NewTableName. It is valid only when the configured migration objects are table-level ones and TableEditMode is pt. To migrate temp tables generated when pt-osc or other tools are used during the migration process, you must configure this parameter first. For example, if you want to perform the pt-osc operation on a table named "t1", configure this parameter as ["_t1_new","_t1_old"]; to perform the gh-ost operation on t1, configure it as ["_t1_ghc","_t1_gho","_t1_del"]. Temp tables generated by pt-osc and gh-ost operations can be configured at the same time.
      Note: This field may return null, indicating that no valid values can be obtained.
      TableEditMode String No Table editing type. Valid values: rename (table mapping); pt (additional table sync).
      Note: This field may return null, indicating that no valid values can be obtained.

      TagFilter

      Tag filter

      Used by actions: DescribeMigrationJobs, DescribeSyncJobs.

      Name Type Required Description
      TagKey String Yes Tag key
      TagValue Array of String No Tag value

      TagItem

      Tag

      Used by actions: CreateMigrationService, CreateSyncJob, DescribeMigrationDetail, DescribeMigrationJobs, DescribeSyncJobs, ModifyMigrationJob.

      Name Type Required Description
      TagKey String No Tag key
      Note: This field may return null, indicating that no valid values can be obtained.
      TagValue String No Tag value
      Note: This field may return null, indicating that no valid values can be obtained.

      TopicRule

      Topic description

      Used by actions: ConfigureSyncJob, DescribeSyncJobs.

      Name Type Required Description
      TopicName String No Topic name
      PartitionType String No Topic partitioning policy. If the topic sync policy is delivering data to multiple custom topics (TopicType = Multi), the value of this parameter is Random (deliver to a random partition). If the topic sync policy is delivering all data to a single topic (TopicType = Single), this parameter has three valid values: AllInPartitionZero (deliver all data to partition0), PartitionByTable (partition by table name), PartitionByTableAndKey (partition by table name and primary key).
      DbMatchMode String No Database name matching rule. This parameter takes effect only when TopicType is Multi. Valid values: Regular (match by regex), Default (default rule for the remaining databases that cannot be matched by regex). The default rule must be included in the array of matching rules.
      DbName String No Database name, which can only be matched by regex when TopicType is Multi and DbMatchMode is Regular.
      TableMatchMode String No Table name matching rule. This parameter takes effect only when TopicType is Multi. Valid values: Regular (match by regex), Default (default rule for the remaining databases that cannot be matched by regex). The default rule must be included in the array of matching rules.
      TableName String No Table name, which can only be matched by regex when TopicType is Multi and DbMatchMode is Regular.

      TradeInfo

      Billing status information

      Used by actions: DescribeMigrationDetail, DescribeMigrationJobs.

      Name Type Description
      DealName String Order number
      Note: This field may return null, indicating that no valid values can be obtained.
      LastDealName String Last order number
      Note: This field may return null, indicating that no valid values can be obtained.
      InstanceClass String Instance specification. Valid values: micro, small, medium, large, xlarge, 2xlarge.
      Note: This field may return null, indicating that no valid values can be obtained.
      TradeStatus String Task billing status. Valid values: normal (billed or to be billed); resizing (adjusting configuration); reversing (topping up, which is a short status); isolating (isolating, which is a short status); isolated (isolated); offlining (deleting); offlined (deleted); notBilled (not billed).
      Note: This field may return null, indicating that no valid values can be obtained.
      ExpireTime String Expiration time in the format of "yyyy-mm-dd hh:mm:ss"
      Note: This field may return null, indicating that no valid values can be obtained.
      OfflineTime String Deletion time in the format of "yyyy-mm-dd hh:mm:ss"
      Note: This field may return null, indicating that no valid values can be obtained.
      IsolateTime String Isolation time in the format of "yyyy-mm-dd hh:mm:ss"
      Note: This field may return null, indicating that no valid values can be obtained.
      OfflineReason String The cause of deletion
      Note: This field may return null, indicating that no valid values can be obtained.
      IsolateReason String The cause of isolation
      Note: This field may return null, indicating that no valid values can be obtained.
      PayType String Billing mode. Valid values: postpay (postpaid); prepay (prepaid).
      Note: This field may return null, indicating that no valid values can be obtained.
      BillingType String Task billing type. Valid values: billing (billed); notBilling (free); promotions (in promotion).
      Note: This field may return null, indicating that no valid values can be obtained.

      View

      Synced view description

      Used by actions: ConfigureSyncJob, DescribeSyncJobs, ModifySyncJobConfig.

      Name Type Required Description
      ViewName String No View name
      Note: This field may return null, indicating that no valid values can be obtained.
      NewViewName String No Reserved field. Currently, a view cannot be renamed. Note: This field may return null, indicating that no valid values can be obtained.

      ViewItem

      View object

      Used by actions: DescribeMigrationDetail, ModifyMigrationJob.

      Name Type Required Description
      ViewName String No View name
      Note: This field may return null, indicating that no valid values can be obtained.
      NewViewName String No View name after migration
      Note: This field may return null, indicating that no valid values can be obtained.
      Contact Us

      Contact our sales team or business advisors to help your business.

      Contact Us
      Technical Support

      Open a ticket if you're looking for further assistance. Our Ticket is 7x24 avaliable.

      Submit a Ticket
      7x24 Phone Support
      Copyright © 2013-2024 Tencent Cloud. All Rights Reserved.
      Privacy PolicyLegalCookie Policy