Comparing deployed routines with routines in the workspace

If you use deployment groups to deploy routines (stored procedures or user-defined functions), you can compare the deployed version of the routine with the version in your workspace.

Before you begin

Deploy a routine to a database server using a deployment group.

About this task

Restriction:
  • If you deploy routines to a database server using a method other than a deployment group, this method cannot fully compare the source on the server to the source in your workspace. However, potential conflicts with routines that have the same name and signature are identified.
  • The same restriction applies if you use different deployment groups to deploy a routine with the same signature to the same server.
  • This feature is currently not supported for Informix® Dynamic Server routines.

Procedure

  1. Right-click a deployment group in the Deployment Manager view.
  2. Select Compare with Server.

Results

Routines that are included in the deployment group are compared with routines on the server, and a window opens to display the results of the comparison.

Feedback