CODEWITHSUNDEEP
openedgeprogress-4glprogress-db
Ezequiel
Ezequiel

Reputation: 75

Track of structure changes in a Progress database

I am asked to automate the tracking of changes in the structure of the database: Any modification, addition or removal of tables, fields, indexes, etc.

I have searched the audit but only found that it can track changes in the "Database schema", which is something else.

Do you know if it is possible to do that?

We use 11.6.3.

Upvotes: 0

Views: 524

Answers (1)

Jensd
Jensd

Reputation: 8011

One wonders how those magical changes in the schema (I think you clarified that it was actually schema changes you wanted to automate) occur. Optionally it could be up to those making the changes to also keep track of them. Usually (hopefully) the database is updated using "delta df-files". Those df-files if kept are a changelog of the database.

Another option is to daily/hourly/weekly dump the data definitions:

CREATE ALIAS DICTDB FOR DATABASE sports.
DISPLAY LDBNAME("DICTDB").

RUN prodict/dump_df.p   ("ALL",
                         "c:/temp/sports.df",
                          "").

DELETE ALIAS DICTDB. /* Optional */

Taken from this entry in the knowledge base: https://community.progress.com/s/article/15884

Then you can diff that df-file using your favorite tool or keep as it is.

If you actually mean structure (that's more how the data is stored in different files on disc) you can use the prostrct command to save a new st-file to disc:

prostrct list sports

This will save a file called sports.st. Handle it as above and you will have a changelog of the database structure.

Upvotes: 4

Related Questions