Batch Incremental utility

Basic Database Tools

Admin Menu Reference : Dump Data and Definitions option : Create Incremental .df File option : 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.