---
title: "POST /v2/job/migration/update"
method: POST
path: "/v2/job/migration/update"
tags: ["job"]
---

# POST /v2/job/migration/update

`POST /v2/job/migration/update`

update migration job.

## Request body

- ModelsCreateOrUpdateMysqlToMysqlJobParamV2
  - `dest_task` ModelsDestTaskConfig, required
    - `connection_config` ModelsDatabaseConnectionConfig, required
      - `database_type` string, required
      - `host` string, required
      - `password` string, required
      - `port` integer, required
      - `service_name` string
      - `user` string, required
    - `database_type` string
    - `mysql_dest_task_config` ModelsMysqlDestTaskConfig
      - `bulk_insert1` integer
      - `bulk_insert2` integer
      - `dependency_history_size` integer
      - `parallel_workers` integer
      - `retry_tx_limit` integer
      - `set_gtid_next` boolean
      - `use_my_sql_dependency` boolean
    - `node_id` string
    - `task_name` string, required
  - `failover` boolean
  - `is_password_encrypted` boolean
  - `job_id` string, required
  - `retry` integer
  - `reverse` boolean
  - `src_task` ModelsSrcTaskConfig, required
    - `chunk_size` integer
    - `connection_config` ModelsDatabaseConnectionConfig, required
      - `database_type` string, required
      - `host` string, required
      - `password` string, required
      - `port` integer, required
      - `service_name` string
      - `user` string, required
    - `drop_table_if_exists` boolean
    - `group_max_size` integer
    - `group_timeout` integer
    - `mysql_src_task_config` ModelsMysqlSrcTaskConfig
      - `auto_gtid` boolean
      - `binlog_relay` boolean
      - `dump_entry_limit` integer
      - `expand_syntax_support` boolean
      - `gtid` string
      - `two_way_sync` boolean
      - `two_way_sync_gtid` string
      - `wait_on_job` string
    - `node_id` string
    - `oracle_src_task_config` ModelsOracleSrcTaskConfig
      - `scn` integer
    - `repl_chan_buffer_size` integer
    - `replicate_do_db` ModelsDataSourceConfig[]
      - `table_schema` string
      - `table_schema_regex` string
      - `table_schema_rename` string
      - `tables` ModelsTableConfig[]
        - `column_map_from` string[]
        - `column_map_to` string[]
        - `table_name` string
        - `table_regex` string
        - `table_rename` string
        - `where` string
    - `replicate_ignore_db` ModelsDataSourceConfig[]
      - `table_schema` string
      - `table_schema_regex` string
      - `table_schema_rename` string
      - `tables` ModelsTableConfig[]
        - `column_map_from` string[]
        - `column_map_to` string[]
        - `table_name` string
        - `table_regex` string
        - `table_rename` string
        - `where` string
    - `skip_create_db_table` boolean
    - `sql_filter` string[]
    - `task_name` string, required
  - `task_step_name` string

## Response `200`

OK

---

[API](https://skmtc.dev/actiontech/apis/dtle-api-docs.md) · [All operations](https://skmtc.dev/actiontech/apis/dtle-api-docs/llms.txt) · [OpenAPI document](https://skmtc-service-production.skmtc.workers.dev/v1/apis/actiontech/dtle-api-docs/revisions/f42616d511c2/schema)