Skip to Main Content

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question, Jayanta.

Asked: March 05, 2020 - 7:42 pm UTC

Last updated: May 16, 2023 - 3:00 am UTC

Version: 12c

Viewed 10K+ times! This question is

You Asked

We have lot of sql scripts both plsql and non pl sql script which are part of parallel release.
We have both DDL and DML scripts. DML scripts are extensive and at times require application downtime.
Currently deployment of these scripts is semi automated.
We used Jenkins to build artifacts and BMC RLM to deploy the same via manual trigger.
We are planning to move towards devops approach and adopt CI/CD.

I need guidance regarding how to start adopt this process and which tools should I learn to use?
Note : We use Oracle 12c.

and Connor said...

We have some good Liquibase support for this. Team member Blaine Carter did a thorough write up of this recently

https://asktom.oracle.com/Misc/oramag/change-happens.html

Also Tim Hall did an intro video to this just recently



Rating

  (1 rating)

Is this answer out of date? If it is, please let us know via a Comment

Comments

Oracle Blog Link doesn't work

Rob K, May 11, 2023 - 5:13 pm UTC

On this page there's a link/reference to this page: https://blogs.oracle.com/connect/post/change-happens
When you click on that link, you get a "Not Found" error. So that page no longer exists at that URL.
Connor McDonald
May 16, 2023 - 3:00 am UTC

Yeah a lot of older Oracle Connect Magazine articles got archived :-(

We captured them as best we could here on the site - but you might lose some images/links etc.

https://asktom.oracle.com/Misc/oramag/change-happens.html

Thanks for letting us know
more

Connor and Chris don't just spend all day on AskTOM. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's latest video and Chris's latest video from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.

More to Explore

PL/SQL demos

Check out more PL/SQL tutorials on our LiveSQL tool.

PL/SQL docs

PL/SQL reference manual from the Oracle documentation library