Batch Incremental utility

This command line utility creates a .df file from comparing two OpenEdge databases. A new file called prodict/dump_inc.p is parallel to prodict/dump_df.p and prodict/load_df.p. Procedure dump_inc.p will query the following environmental variables:

  • DUMP_INC_DFFILE — Name of file to dump to
  • DUMP_INC_CODEPAGE — Output code page
  • DUMP_INC_INDEXMODE — Index-mode for newly created indexes; allowed values are active or inactive
  • DUMP_INC_RENAMEFILE — Name of the file that contains rename information. The format of this file is:
    • T, <old-table-name>,<new-table-name>
    • F, <table-name>,<old-field-name>,<new-field-name>
    • S,<old-sequence-name>,<new-sequence-name>
Note: There is no need to rename indexes because the code compares index elements and changes them automatically.
  • DUMP_INC_DEBUG
    • 0 = debug off, only errors and important warnings
    • 1 = all the above plus warnings
    • 2 = all the above plus configuration information

The first connected database is the source database and automatically receives the alias DICDB.

Use the following code to call the "dump_inc.p" procedure:

OpenEdge-install-dir/bin/_progres -b -db source-db -db target-db -p prodict/dump_inc.p

The resulting delta.df file can then be applied to the target database, giving it the same definitions as the source database.