To generate a stored procedure definition (SPD) file

  1. Using the Extract Schema tool, extract a schema that contains a stored procedure.
  2. From the HCO for SQL Server interface, click Generate SPD File.
  3. Select either Local or Shared to populate the Schema Extract File drop-down list.
  4. 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.

  5. Check the box next to each stored procedure you want to generate.
  6. 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.
  7. In the SPD group, type a name for the generated SPD file into the File Name field. Do not include the .spd file extension.
  8. 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.
  9. 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.
  10. Click Generate.
  11. Specify a file location if prompted.