Data Migration Validation
This comparison option is used to compare the same type of schema.
Data Migration Validation Flow
Drag a Source component from the palette to the canvas.
Choose the Input Source Configuration and select the tables for Data Migration Validation.
Drag a _Target _component from the palette to the canvas.
Choose the Input Source Configuration and select the tables for Data Migration Validation.
Drag a Data Compare component and join the connections.
Select Data Migration Validation from the drop-down menu that appears at the bottom of the screen.
In the Mapping tab, the tables with the same name are auto mapped. You can manually map the other tables and the corresponding columns.
If the column type differs, the system will show a red icon with the following message to the user "Schema should be same for data migration compare" beside the table mapping.
Remove the column/table if different type of columns are mapped.
Data types should be the same for Data Migration validation.
Save and execute the flow.
We can compare the selected source and destination tables to view
Source and Destination Record Distribution.
Source and Destination Data Mismatches.
Success/failure results of each mapped column are shown in Test Case Report.
Last updated