We use Bamboo builds (though I don't know all the technical details of the
setup as Dev/DevOps stood all that up some time ago).
Bamboo server(s) run the builds against the target CI databases (the CI
databases are in a pool so the bamboo builds will get one db out of the
pool that doesn't have a build currently running against it)
In our env we use storage snapshots , so the bamboo build process calls an
api to snap the storage for the master CI database and refresh the clone it
chose - it unmounts the filesystems , remounts them with the latest snap,
and proceeds to run the development code.
I know that's not much help technically, but its more to give you an idea
of how one org has theirs set up.
Chris
On Fri, Jan 15, 2021 at 1:35 PM Jeff Chirco <backseatdba@xxxxxxxxx> wrote:
For those that are, what are you using for Continuous
Integration/Development in your shop? We are starting to look for some. We
have a good manual system where all changes get deployed by calling a
single "install.sql" file, that file calls other files to compile packages,
modify data and tables,etc but if gives us the DBA a single file to run.
And we use Git but I would really like to get to the point where we can
approve changes and then they automatically get deployed when the
developers want them instead of us always having to run them. It does sound
kind of scary for things to run on their own but I think we need to get
there.
We do a lot of custom development and have a single database that runs
many different applications with many different schemas. So those pay per
schemas would not work well for us. There are times where we are doing 10
or more updates in a day, some big some are single file changes, again
across different applications. We have another smaller database that is
also set up similar.
We are looking at Flexdeploy. I did not like Liquabase and having to have
everything in XML files, that seems like it would cause more work. I know
there is Jenkins and one of our developers is looking at that.
Let me know what you use or the pros and cons of the whole idea.
Jeff
