Set Up the HCO_Test SQL Server Database

Guides you through the steps required to create the HCO_Test SQL Server database, create a schema in the database where you can place your migrated DB2 tables, and create a connection to the database.

Create the database and schema

  1. Start the Microsoft SQL Server Management Studio.
  2. Connect to the server where you want to create your database.
    Note: The user ID and password you provide must log you on to SQL Server with dbadmin or sysadmin permissions that enable you to create a SQL Server database.
  3. Create a SQL Server database named HCO_Test.
  4. Create a schema named DSN8910 for the new database:
    1. In Object Explorer, expand HCO_Test.
    2. Right-click the Security folder, and click New > Schema.
  5. Close SQL Server Management Studio.

Create the HCODemo connection

  1. In Visual Studio, click View > Micro Focus SQL Tools > HCO for SQL Server Tools.
  2. From the HCO for SQL Server interface, click Manage Connections.
  3. Select the User Connection Type.
  4. From the Connection List tab, click New SQL Server Connection. This takes you to the SQL Server Connection tab.
  5. In the Data Source Name field, type HCODemo.
  6. Click Integrated Windows Authentication to select it. This means that SQL Server uses your Windows logon credentials to access the database.
  7. In the SQL Server Instance field, type the name of your SQL Server instance. If you have a default instance, this could be . or (local). If you have a named instance, use the combined server name and instance name. For example: mysqlserver\myinstance.
  8. Click Confirm Server to confirm that HCOSS can locate your specified SQL Server Instance.
  9. Check Use a database other than the default database:.
  10. From the Database drop-down menu, select the HCO_Test destination database that you created in SQL Server Management Studio.
  11. Click Test. If the test fails, review your field entries, make corrections accordingly, and try again. When you have a successful connection, click OK.
  12. Click Save to save the connection. This takes you back to the Connection List tab where you should now see your SQL Server connection listed.
Parent topic: Tutorial: Mainframe Batch Database Tools (MBDT)
Next topic: Prepare Mainframe Data