Tutorial: Create a Sample Database

Run SQL scripts that create the sample database required to complete these tutorials and populates the database with the necessary data.
Requirement
Before attempting this tutorial, you must complete Tutorial: Enable SQL CLR Integration.
Create the SQLCLR_Test Database
  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: Prerequisites