- 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
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
. 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.