P
Peter Judge
Guest
We only version the full df also. We have an ant/PCT script that takes said df from the repository, creates a temporary DB, makes a delta.df to the master and then applies that to the master. It requires you having a compile time license, but it takes all the effort and stress out of schema management. It's also a relatively simple process, and with PCT now shipping with your Progress install, it makes sense to use it! One of the things to be aware of when applying schema changes is what to do with any data that's affected by those changes. If you drop fields/tables, where does that data go? If you add new tables or fields, do they need to be populated? Etc etc etc. This may make what you consider a schema change much larger and you may want to add some form of 'application db version' into your database(s). You always need a compile-time license when working with the data dictionary (due largely to how it was written, with arguments to procedures instead of parameters).
Continue reading...
Continue reading...