Skip to main content

Whole Database

Overview​

The Whole Database DataJob supports tables and data that are added, modified, or deleted during synchronization.

This article introduces how to create a Whole Database DataJob using MySQL to MySQL synchronization as an example.

Steps​

  • Log in the CloudCanal console.

  • DataJob > Create DataJob.

  • Select the source and target DataSource.

  • Select Advanced of source DataSource and check Full Database option.

  • Click Next Step. create_all_db_1.png

  • Select Incremental and check Full Data option.

  • Click Next Step. create_all_db_2.png

  • Tables are not selectable but actions(insert,update,delete...) can be selected.

  • Click Create DataJob. create_all_db_3.png

  • By default, the miss schema in target will be migrated. create_all_db_4.png

  • Details > Mapping:View will show all tables in selected schemas. create_all_db_6.png

  • When DataJob is in Incremental,Details > Functions > Modify Subscription, where can add or reduce schemas. create_all_db_5.png