Tutorials: HCO for SQL Server (HCOSS)

Note: This feature was added in Enterprise Developer version 8.0 Patch Update 1.
Includes tutorials that guide you through the process of migrating a DB2 application to a SQL Server application.
Attention: This feature is in Early Adopter Program (EAP) release status. We intend to provide the finalized feature in a future release. Please contact OpenText Support for Micro Focus Products if you require further clarification.

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:

  • You are running the latest version of 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.
  • The Eclipse IDE is started on your local machine, and the appropriate Perspective and View are open..
  • Eclipse options are set to build projects automatically.
  • You have addressed all of the items in the Before you begin a tutorial section below.

Before you begin a tutorial

Enterprise Server Security
In this release, the Enterprise Server security features are enabled by default. Tutorials that use enterprise server regions, however, assume that Enterprise Server security is not configured. To work though this tutorial unchanged, you need to disable any configured Enterprise Server security. See To Disable the Default Enterprise Server Security Configuration for details.
Important: Micro Focus does not recommend disabling the security permanently. Re-enable it as soon as possible after completing tutorials. See To Recreate the Default Enterprise Server Security Configuration. For more information, see also After Installing > Enterprise Server Security Considerations.
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.
Start Enterprise Developer
Start Enterprise Developer using the default workspace, which is $home/workspace. If you need instructions to get Enterprise Developer started on your local machine, see To start Enterprise Developer.
Note: If Visual Studio prompts you on startup to select an initial action, click Continue without code.
Open the Team Developer Perspective and Application Explorer View in Eclipse
When you start Enterprise Developer for the first time, the Team Developer perspective starts automatically by default, and shows the Application Explorer view. If this is not the case, open the Team Developer perspective as follows:
  1. From the Eclipse IDE, click Open Perspective Open Perspective.
  2. On the Open Perspective dialog box, select Team Developer (default), and then click Open.

In addition, the Enterprise Development Projects system should be loaded in the Application Explorer view. To confirm this:

  • In the Application Explorer view, you should see the Enterprise Developer system. If the system is not shown, to load it:
    1. Right-click in the Application Explorer view, and then click Add System(s).
    2. In the Add System(s) dialog box, select ED System and click OK.
    3. Expand the top-level Enterprise Developer entry in the Application Explorer view.
    4. Right-click Enterprise Development Projects; then click Load Application.
  • Otherwise, expand the Enterprise Developer system. An entry titled Enterprise Development Projects should appear indicating that the system is loaded.
Set Eclipse to build automatically
By default, the Eclipse Build Automatically option is turned on, which means that Eclipse builds a project automatically each time a change is made. To ensure that this Build Automatically is turned on:
  1. From the Eclipse Main Menu, click Project.
  2. Do one of the following:
    • If the Build Automatically menu option has a check mark to its left, it is already turned on. No further action is required.
    • If the Build Automatically menu option does not have a check mark to its left, click the option to turn it on.

Sequence