Walks you through the process of using the Compare Data HCOSS UI tool to compare the extracted DB2 data with the data transferred
into the new SQL Server database.
Compare data
- From the HCO for SQL Server interface, click
Compare Data.
- Select an appropriate
Source Connection and
Destination Connection.
- Click
New to create a new compare data task.
- In the
Name field, type
schema-nametest.
- From the
DDL Task drop-down list, select
schema-nametest.
- Click
OK.
- Click
Save to save the compare data task.
- Click
Compare to compare the data. This takes you to the
Results tab where you can view messages as the tool compares the data.
Repeat
- Compare data for another DDL task by repeating the procedure, using the following information:
| Compare Data task name |
schema-nameprod |
| Associated DDL task |
schema-nameprod |
| Source connection |
mainframeDB2 |
| Destination connection |
HCODemo |
- Save and compare.
This concludes the tutorial.