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.

Data Migration Validation Comparison

Data Migration Validation Mapping

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.

Data Migration Validation Summary Results

Data Migration Validation Summary Results

Data Migration Validation Test Case Report