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_DUMPSECTION — Dump the sections that support online schema changes. For old format, the value is No.
  The following code is the new format batch script:

  #!/bin/sh
  DUMP_INC_DFFILE=/tmp/delta.df
  DUMP_INC_CODEPAGE=iso8859-2
  DUMP_INC_INDEXMODE=active
  DUMP_INC_DUMPSECTION=No
  DUMP_INC_RENAMEFILE=/tmp/master.rf
  DUMP_INC_DEBUG=2
  export DUMP_INC_DFFILE DUMP_INC_CODEPAGE DUMP_INC_INDEXMODE DUMP_INC_DUMPSECTION DUMP_INC_RENAMEFILE DUMP_INC_DEBUG
  
  $DLC/bin/_progres -b -db master -db slave -p prodict/dump_inc.p/tmp/dump_inc.log
  

  Note: By default, DUMP_INC_DUMPSECTION is set to No. Also, if no value is specified, then the old format .df file is used.
• 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>

• 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.