Sometimes only subset of data need to migrate.
There are two types of the subset:
Row Subset - in this case user will define/limit rows for the migration as the SQL’s “WHERE“ condition.
Workflow → Tables → Fill the “Subsetting“ field:
Important!: The value of the Subsetting field must be the valid “WHERE“ condition. Otherwise it leads to the migration fail.
Column Subset - user will be able to check/un-check the specific columns for migration. If some column was not checked then the data will not be read from the source database.
Workflow → Tables → Click on the icon in the “Columns“ field:
As result the selected table will appear in the destination database without un-checked columns.
Important!: The Column Subset with Overwriting methods “Tables“ and “No Overwriting” leads to the migration fail.