Sometimes only subset of data need to migrate.
...
Workflow → Tables → Fill the “Subsetting“ field:
...
Important!: The value of the Subsetting field must be the valid “WHERE“ condition for the Source Database Type (See the Known Issues and Examples). Otherwise it leads to the migration fail.
...
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. Also the migration will fail if the un-checked column has indexes or foreign key.
Known Issues:
Different databases have different (sometimes incompatible) syntax.
Examples:
1. Oracle
The original SQL query:
SELECT
user_id, address
FROM
customers
WHERE
last_name = 'Anderson'
The string for the Subletting: last_name = 'Anderson'
2. MySQL
Query:
SELECT
name,
price
FROM
products
WHERE
price < 1.0 OR
productCode = 'PEN'
The Subsetting-string: price < 1.0 OR productCode = 'PEN'
3. For PostgreSQL
Query:
SELECT
first_name,
last_name
FROM
customer
WHERE
first_name LIKE 'Bra%' AND
last_name <> 'Motley'
The Subsetting-string: first_name LIKE 'Bra%' AND last_name <> 'Motley'