Kbase P3189: How to deploy database schema changes programatically in an automated fashion
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
1/26/2005 |
|
Status: Verified
GOAL:
How to deploy database schema changes programmatically in an automated fashion
FIX:
To load schema changes (data definitions .df) programmatically, the data administration code can be accessed through a RUN statement as follows:
1.) From the command line where the DLC and PATH environment variables have been set correctly to the Progress version in use:
$ mpro -p my_program.p -ld dictdb -rx
my_program.p contains:
RUN prodict/load_df.p ("path_to_df/df.name").
QUIT.
and is compiled under connect to any db with -ld dictdb
In Progress 8.x load_df.p is under $DLC/src/prodict and during the compilation needs PROPATH to also be set to $DLC/src
In Progress 9.x load_df.p is contained within a .pl file that must be extracted. See Solution ID: P13682 for instructions.