- Using the Extract Schema tool, extract a schema that contains a stored procedure.
- From the HCO for SQL Server interface, click
Generate SPD File.
- Select either
Local or
Shared to populate the
Schema Extract File drop-down list.
- Select a schema extract file from the drop-down list.
The stored procedures available in the schema extract file show on the
Select procedures to generate grid.
- Check the box next to each stored procedure you want to generate.
- If the fields in the
Post Deployment group are enabled, specify the full path to and file name of a post-deployment script in the corresponding
File Name field, type the default namespace for the
Visual Studio project into the
Namespace field, and ensure that
Generate changes is checked. See
Post-Deployment Script Requirements for complete information.
Important: When you create your project using the SQL Server Database Project template, you must manually create and add the post-deployment
script file to the
.Publish project before completing these fields. See
To add a post-deployment script for more information.
- In the SPD group, type a name for the generated SPD file into the
File Name field. Do not include the
.spd file extension.
- If your generated SPD file passes parameters to a SQL CLR Stored Procedure definition routine, and you want to pass all of
those parameters as fixed length, check
Generate fixed-length parameters.
- If you want to also generate a COBOL wrapper program and automatically add it and the generated SPD file to your current project,
check
Add file to active project. Optional.
Note: The
Add file to active project check box is available only when you open HCOSS from within the IDE and you have an active SQL CLR Database project open
in
Visual Studio. If you do not add the SPD file and COBOL wrapper program to the project at this time, you can add them to any project as
Existing Items.
- Click
Generate.
- Specify a file location if prompted.