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: