Feedback

  • Contents
 

Configure Dependencies

Use the Configure Dependencies dialog box to add SQL dependencies (such as tables, procedures, functions, and views) to include when exporting files for this client.

To configure dependencies

  1. In the Navigation pane, click Clients.

Clients pane

  1. In the Clients pane, expand the appropriate folder and then double-click the client. The tab for the specified client appears in the Information pane.

General tab

  1. On the General tab in the General Configuration section, click Configure Dependencies. The Configure Dependencies dialog box appears.

Configure Dependencies dialog box

  1. Click Add SQL Dependency. The Dependency Designer dialog box appears.

Dependency Designer dialog box

SQL object type: Type of SQL object.

Object Name: Name of the SQL object.

Show Definition: Displays the object's contents.

  1. Complete the information and then click OK. The system populates the Configure Dependencies dialog box with the specified SQL dependency.

  2. To view the script, do the following:

    1. Click Show Create Script. The Dependency Script dialog box appears.

Dependency Script dialog box

    1. To export the script to a file, click Export, specify a file name, and then click Open.

    2. To close the Dependency Script dialog box, click the X in the title bar.

  1. Add as many dependencies as the client requires and then click OK.

  2. In the toolbar, click Save. The Update Comment dialog box appears.

  3. In the Update Comment box, type a comment regarding your changes and then click OK.

Related Topics

Specifying General Configuration Settings

Configure File Pre-Processing

General Configuration