Modify the migration task properties

Note: This task is optional.
  1. On the Properties section, under Mapping Properties, modify the name of the migration task.
  2. Under Source Properties, specify an SQL WHERE clause.
  3. Under Destination Properties, specify this information:
    WhereClause
    Specify an SQL WHERE clause.
    DuplicateCheckFields
    Specify the field names that will be checked for duplicate values.

    The field must be from the destination table. When a migration task is ran, records with matching values with the defined fields in DuplicateCheckFields will not be inserted to the destination table. You can specify multiple fields, separated by comma.

    SkipIfNullFields
    Specify the field names that will be checked for null or empty values.
    Note: The fields must be from the destination table. When the migration task is ran, records with null or empty values on the fields that are specified in SkipIfNullFields will be skipped during the process of inserting information to the destination table. You can specify multiple fields, separated by comma.