Comparing and merging routine source code

You can use the compare editor to compare and merge the source code of routines that are stored in a data development project.

Before you begin

Before you can compare and merge routines, you must create more than one routine in a data development project.

About this task

These instructions describe how to compare and merge the source code for routines that are stored in a data development project. You can also compare routines at a file (*.spxmi) level by right-clicking two routines and selecting Compare With > Each Other. However, comparing and merging at a file level is error-prone and is not recommended.

Procedure

To compare and merge routine source code:

  1. Right-click two routines of the same type, and select Compare With > Each Other's Routine Source. You can select two routines that are stored in two different data development projects. However, the routines must be of the same type. For example, you can compare two SQL stored procedures, but you cannot compare an SQL stored procedure to a Java stored procedure. The compare editor opens.
  2. Use the toolbar icons in the compare editor to merge changes from one routine to the other, then press Ctrl + S to save your changes. You can also make changes by typing directly in the compare editor.

Results

The changes that you made in the compare editor are added to each routine.

Feedback