Tutorials: HCO for SQL Server (HCOSS)

Includes tutorials that guide you through the process of using the HCOSS toolset to perform a DB2 database migration, and to use the Mainframe Batch Database Tools (MBDT) to perform a DB2 database migration. They also provide three different scenarios in which you migrate a DB2 application to a SQL Server application.

Assumptions

These tutorials are written from the perspective that all of the following is true. Specific instructions for setting up your environment to adhere to these assumptions is found in the Before you begin a tutorial section that follows:

  • Windows File Explorer is set to show file names and extensions.
  • Windows User Account Control (UAC) is turned off.
  • You are running the latest version of Micro Focus Enterprise Developer, which has been installed on your local machine using default installation settings.
  • You have installed and can access a supported version of Microsoft SQL Server.
  • Enterprise Developer is started on your local machine.
  • For SQL CLR Stored Procedures tutorials only, the Microsoft Windows Software Development Kit (SDK) for your version of Windows is installed.
  • Your parent project directory is c:\tutorials\HCOSS. If you choose to use an alternative parent project directory, adjust the instructions accordingly.
  • You have addressed all of the items in the Before you begin a tutorial section below.

Before you begin a tutorial

Install Microsoft SQL Server
To complete any of the HCOSS tutorials, you must have Microsoft SQL Server, including the SQL Server Management Studio, installed and configured on your machine. For information on supported versions, see the HCO for SQL Server (HCOSS) section of the Database Management Systems (DBMSs) topic.
Install the Windows SDK
For SQL CLR Stored Procedures tutorials only. See the Microsoft Web site for more information.
Set Windows File Explorer options
These tutorials assume that your Windows File Explorer options are set to use the Details layout, and to show file name extensions. See your Windows documentation for more information.
Turn off Windows User Account Control (UAC)
Depending on the Windows UAC setting on your machine, HCOSS exhibits different behavior for some features. The differences in behavior are dependent on things such as whether or not you are logged in as a standard user or an administrator, whether or not you are a member of the Windows Administrators group, and how you start the HCOSS user interface. These tutorials assume that you have turned UAC off by setting it to Never notify. See your Windows documentation for details.
Create a parent project directory
Create a working directory in which to store the projects and other files created or required for this series of tutorials. All tutorials in this set cite a parent project directory of c:\tutorials\HCOSS.
Start Visual Studio
If you need instructions to get Visual Studio started on your local machine, see To start Visual Studio.

Sequence

These HCOSS tutorials are not interdependent and may be done in any order: