Schema Compare

This type of comparison will compare the table schema, which is to say, compares the columns with their data types. If data types don't match, then the test is considered as failed.

Schema Compare Flow

• Drag a Source component from the palette to the canvas.

• Choose the Input Source Configuration and select the tables for schema compare.

• Drag a _Target _component from the palette to the canvas.

• Choose the Input Source Configuration and select the tables for schema compare.

• Drag a Data Compare component and join the connections.

• Select Schema Comparison 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.

• Save and execute the flow.

Schema Compare Result shows how well the source and target schema match.

Summary presents the matched/mismatched tables count and the total matched/mismatched columns count.

Details arranges the total tables matched and mismatched information based on the Column Data Type.

Schema Compare Mapping

Schema Compare Result

Schema Compare Stats

Schema Compare Details