Good afternoon fellow Progress peoples,
This is more of an opinion question. What processes are you guys using to use source control to track changes to maintenance type tables and data? I've seem tools like phing for PHP used with a mysql database. Is there something that others are doing specifically with Progress?
At our customer we've done they same as other Mike did. Export data as formatted xml; menu, authorisation, repository and more. Version control is most of the time able to merge the differences per change.
We're now actually starting to remove the data from the database and start using the xml at runtime. As this data is read only at runtime we've found no gain to read it from a database but this depends on the amount of data of course. It also helps developers not to have a repository database either shared or separetly maintained and it solves the delete problem. Our appserver agents read a couple of hundred xml files into static temp tables and we did not have to change any code in the framework.