Transfer Data and Verify

Provides steps to guide you through the process of using the Transfer Data HCOSS UI tool to populate the schema objects in your SQL Server database with data from your DB2 database.

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

  • In the Visual Studio Server Explorer, view the table data for the HCO_Test database's TEST.DEPT table.

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.