[Progress Communities] [Progress OpenEdge ABL] Forum Post: RE: CI/CD for OpenEdge Databases: State or Migration?

  • Thread starter Thread starter Peter Judge
  • Start date Start date
Status
Not open for further replies.
P

Peter Judge

Guest
I think that /delta001 should contain the schema, data and programs for that update version. So you could have something like /db1 /full Full.df Table1…N.D Sequence data /001 Delta.df Table3.d Update-table3.p Etc One reason to have the code in the /001 folder is that the rcode produced for those update programs may change based on the df that's applied. So you will also need to make sure your build scripts can deal with that. You can see the scripts we used for Dynamics in github.com/.../adebuild , particularly pbuild and pbuildfxprg . You'll also need a "driver" program; one that - queries the current db's existence and (application)version - determines the target version - applies the update versions (/001 to /005 or whatever) and update the db-version - I think you'll need to think about what the level of atomicity is. I'd think not less than a single update is appropriate but it'll depend.

Continue reading...
 
Status
Not open for further replies.
Back
Top