SSMA provides an ability for you to customize sql statement used during data migration. This feature can be used in the following scenarios:
To customize data migration sql statement:
The final setting should look like below:
Note: You must convert the schema and synchronize the schema to the SQL Server before migrating your data
You may migrate additional data by repeating Step 7 -10 and updating the sql statement each time (for example: WHERE DEPARTMENT_ID=101). Make sure to uncheck Truncate SQL Server table option if you want to append records to the destination table
You can use the steps above to customize your data migration. Let us know what you think of the feature above.
Great article. Thank You very much.