Transfer Data and Verify

Transfer data

1. From the HCO for SQL Server interface, click Transfer Data. This takes you to the Transfer Data Tasks tab.
2. Click New to create a new transfer data task.
3. In the Name field, type schema-nametest.
4. From the DDL Task drop-down list, select schema-nametest.
5. Click OK.
6. From the Source Connection drop-down list, select mainframeDB2, which is the name of your DB2 connection.
7. From the Destination Connection drop-down list, select HCODemo, which is the name of your SQL Server connection.
8. Click Save to save the task.
9. Click Transfer to transfer the list. This takes you to the Results tab where you can view log messages as the transfer takes place.

Verify the data transfer

Repeat

1. Transfer data for a different DDL task by repeating the procedure, using the following information:

   Transfer Data task name	schema-nameprod
   Associated DDL task	schema-nameprod
   Source connection	mainframeDB2
   Destination connection	HCODemo

2. Save, transfer, and verify.