Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Search instead for
Did you mean:
How to use a user-defined condition to migrate rows in MTK
Users of EDB Migration Toolkit (MTK) can migrate specific rows rows by defining a condition in a file and then referencing it with the -filterProp option.
The format of the file referenced by -filterProp contains a constraint represented as a key=value pair. Each record read from the database is evaluated against this constraints, and only those that satisfy the constraint are migrated. The left side of the pair lists a table name (please note that the table name should NOT be schema-qualified). The right side specifies a condition that must be true for each row migrated. For example, countries=country_id<>'AR' migrates only those countries with a country_id value that is not equal to 'AR'; this constraint applies only to the countries table.
NOTE: Only one condition can be specified in the -filterProp file. If a user wants to use mulitple conditions at the same time then can initiate multiple migrations (run multiple instances of MTK) with different prop files, but it may have its own drawbacks (like multiple DB connections etc..).