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
-
- Start SQL Server Management Studio.
- Open the
CreateAndLoadSQLCLR_Test.sql script, located in your
%PUBLIC%\Documents\Micro Focus\Enterprise Developer\Samples\sql\sqlclr directory.
- Execute the script.
This creates the
SQLCLR_Test database and populates its tables with sample data necessary for stored procedure deployment.
- Open the
setupcounter.sql script, located in your
%PUBLIC%\Documents\Micro Focus\Enterprise Developer\Samples\mainframe\sql directory.
- Execute the script.
This creates an additional table, TEST.COUNTER, used by the JCL samples.
- Exit SQL Server Management Studio.
