Try OpenEdge Now
skip to main content
Basic Database Tools
Admin Menu Reference : Dump Data and Definitions option : Create Incremental .df File option : Batch Incremental utility
 
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.