Tutorial: DB2 Database Migration using HCOSS

Takes you through each step in the process of migrating a mainframe-based DB2 database to a Microsoft SQL Server database using HCO for SQL Server database migration UI tools.

Prerequisites

  • Review the Assumptions and Before you begin a tutorial section in the Tutorials: HCO for SQL Server (HCOSS) topic to ensure your environment is set up properly.
  • You must have access to a mainframe DB2 database for which you can create a DB2 connection by supplying:
    • Your DB2 database user ID and password
    • The IP address used on your network to connect to your mainframe DB2 database
    • The port number used to access your mainframe DB2 database
    • The name of the catalog used by your DB2 database
    • The name of the package collection your DB2 database uses to talk to mainframe DB2 via a database connection
    • The DB2 CCSID value to use in program connection strings
  • Install and configure the Microsoft OLEDB Provider for DB2 onto your local machine. See the HCO for SQL Server (HCOSS) topic under Additional Software Requirements for details.

Demonstration application

This tutorial uses any DB2 database on your mainframe that includes a SYSIBM or other file containing your mainframe system catalogs.

Sequence

To complete this tutorial, progress through these topics in the order presented here. The bottom of each topic provides Next topic and Previous topic navigational links to help you proceed in the proper sequence:

  1. Set Up HCO_TEST SQL Server Database Access
    Guides you through the process of creating the HCO_Test SQL Server database, and creating the HCODemo SQL Server connection to access it.
  2. Start HCO for SQL Server from Visual Studio
    Provides instructions for starting HCOSS from the Visual Studio IDE.
  3. Create the mainframeDB2 DB2 Database Connection
    Guides you through the process of using the Manage Connections HCOSS tool to create a connection to your DB2 database so you can access its SYSIBM tables.
  4. Extract and Review an XML Representation of a DB2 Schema
    Walks you through the process of using the Extract Schema UI tool to download the standard DSN schema from your DB2 database in the form of an XML file that contains its information, and view that file in a text editor.
  5. Create a Transfer List
    Provides instructions for using the Define Lists HCOSS UI tool to create a list of objects from the DB2 schema you extracted. Later in this tutorial, HCOSS uses this transfer list to identify the objects associated with this extraction and migration.
  6. Generate DDL and Verify the SQL Server Database Structure
    Takes you step-by-step through the process of using the Generate DDL HCOSS UI tool to generate DDL from the schema objects in your object transfer list, and then verifying the generated SQL Server structure using the Server Explorer in VisualStudio.
  7. 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.
  8. Compare DB2 vs. SQL Data
    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.
Parent topic: Tutorials: HCO for SQL Server (HCOSS)
Related concepts
Database Management Systems (DBMSs)
Tutorials: HCO for SQL Server (HCOSS)