You should ask yourself what is your current organization using for SW
deployments and see if that would work for you too, instead of introducing a
new tool chain into the environment.
Tools I have used in the past to deploy Oracle SW, Oracle Patches, Oracle
Databases, Oracle PDBs, Monitoring implementation/changes, DBA scripts, DDL
changes, etc include
Open Source:
Puppet, Chef, Ansible, OpenCrowbar, SaltStack, Docker, CFEngine, Jenkins
Pay to Play:
Enterprise Puppet, OEM Configuration Management Pack, Microsoft Team
Foundation Server.
There are a lot more than these. It depends on what you really need/want to
do. Some are easier to use than others for certain tasks.
Extreme caution is advised here as most with most deployment SW you are
turning over access to your database to a tool that is controlled by someone
else who is not within infrastructure or databases. This has been the real
rub as most of the automation SW is controlled by DEV teams. In a lot of
organizarions we divide up deployments into different tools so that
databases align with infrastructure deployments instead of SW deployments.
Things as simple as DDL deployments that a dev simply pushed code into the
deployment that basically from the designer tool performed a drop
table/create table on the production tables and we had to restore from
backup. Yes it was tested all the way up the stack but in DEV/QA it
generated all of it's data for the testing scenarios with the data
generation simply not being apart of the Prod deploy.
You just need to think carefully about what you are allowing to happen on
your systems. It doesn't matter how much the DevOPS guys try to tell you
about the approval processes in the tool there is always an override or
structural modification that an admin on that side or developer because the
admins are really apart of the DEV team and gives everyone access that the
controls doesn't stop badness from happening.
Some links
https://blog.profitbricks.com/48-best-cloud-tools-for-infrastructure-automat
ion/
Matthew Parker
Chief Technologist
Dimensional DBA
425-891-7934 (cell)
D&B 047931344
CAGE 7J5S7
Dimensional.dba@xxxxxxxxxxx
View Matthew Parker's profile on LinkedIn
www.dimensionaldba.com
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Karth Panchan
Sent: Thursday, August 18, 2016 5:41 PM
To: vijaysehgal21@xxxxxxxxx
Cc: ORACLE-L
Subject: Re: Tools for automating database build and deployment
Check Liquibase. Nice open source tool. It allows release management.
Nice integration with Maven and Jenkins.
Karth
Sent from my IPhone
On Aug 18, 2016, at 8:07 PM, vijayrsehgal <vijaysehgal21@xxxxxxxxx> wrote:working towards automating release process of database scripts and
Dear Experts,
This was not my area of work, but in my present organization the team is
could shed some light on which tools are used.
I have never worked in this area before, so I thought if experts here
--
Thanking you for your time and help.
Regards,
Vijay Sehgal
