Create the SQLCLR_Test Database

Walks you through the process of creating the sample database required to complete these tutorials, and populate the database with the necessary data.
  1. Start SQL Server Management Studio.
  2. Open the CreateAndLoadSQLCLR_Test.sql script, located in your %PUBLIC%\Documents\Micro Focus\Enterprise Developer\Samples\sql\sqlclr directory.
  3. Execute the script.

    This creates the SQLCLR_Test database and populates its tables with sample data necessary for stored procedure deployment.

  4. Open the setupcounter.sql script, located in your %PUBLIC%\Documents\Micro Focus\Enterprise Developer\Samples\mainframe\sql directory.
  5. Execute the script.

    This creates an additional table, TEST.COUNTER, used by the JCL samples.

  6. Exit SQL Server Management Studio.
Parent topic: Tutorial: Prepare the SQL CLR Stored Procedures Environment
Previous topic: Enable SQL CLR Integration
Next topic: Create an ODBC 32-bit System Connection