RE: Tools for automating database build and deployment

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_at_comcast.net
View Matthew Parker's profile on LinkedIn www.dimensionaldba.com

-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Karth Panchan
Sent: Thursday, August 18, 2016 5:41 PM
To: vijaysehgal21_at_gmail.com
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_at_gmail.com> wrote:
>
> Dear Experts,
>
> This was not my area of work, but in my present organization the team is
working towards automating release process of database scripts and deployment.
>
> I have never worked in this area before, so I thought if experts here
could shed some light on which tools are used.
>
> Thanking you for your time and help.
>
> Regards,
> Vijay Sehgal
>
>

--
http://www.freelists.org/webpage/oracle-l



--
http://www.freelists.org/webpage/oracle-l