Search for a command to run...
Series
Everything you need to know about database schema changes control using Open Source Liquibase & Oracle SQLcl Liquibase
Introduction Many organizations have implemented DevOps in their applications. At the same time, their database change process hasn’t evolved and is still left in the dark ages. But what if you could automate that, too? It can be done using Liquibase...
This blog gathers together all you need to install standalone Open-Source Liquibase 4.25.1, configure it and use it with your Oracle databases - both on-premise and OCI Cloud (ATP, ADW, etc.) These instructions cover MacOS & Windows. See my other art...
![[Open Source Liquibase] Installation on Mac&Windows and how to use it with Oracle Database (on-premise & cloud)](/_next/image?url=https%3A%2F%2Fcdn.hashnode.com%2Fres%2Fhashnode%2Fimage%2Fstock%2Funsplash%2FAIIC6wCqkQc%2Fupload%2F52c9001ba7004a767347c7b7fb21dd30.jpeg&w=3840&q=75)
This blog gathers together all you need to install SQLcl (Open-Source Liquibase 4.18.0 is included, no need for a separate installation), configure it and use it with your Oracle databases - both on-premise and OCI Cloud (ATP, ADW, etc.). MacOS & Win...
![[Oracle SQLcl Liquibase] Install it on Mac&Windows and use it with Oracle Database (on-premise & cloud)](/_next/image?url=https%3A%2F%2Fcdn.hashnode.com%2Fres%2Fhashnode%2Fimage%2Fstock%2Funsplash%2FbAGo7O4prtY%2Fupload%2F7cb850ce73d429383a2a2a9c8b6073da.jpeg&w=3840&q=75)
In the previous episode, we learned to capture all objects from the DEV schema and move them to UAT. In this part, I will make a few changes on DEV and move them to UAT. I won't have to think about what should be moved to UAT and in which order. SQLc...
![[Mastering Oracle SQLcl Liquibase - Part 2/3] Track your DEV database changes and move it to UAT(or any other environment)](/_next/image?url=https%3A%2F%2Fcdn.hashnode.com%2Fres%2Fhashnode%2Fimage%2Fstock%2Funsplash%2F_SEbdtH4ZLM%2Fupload%2F119e3bbf2b87b59db1f851c3aafc647e.jpeg&w=3840&q=75)
You won't have direct access to ANY Oracle database in some projects. That's a fact. You will probably prepare SQL scripts using exported objects from the GIT repository. After that, you or someone else will execute those scripts "by hand". What if y...
![[Open Source Liquibase] Track your database changes offline - no direct connection is required](/_next/image?url=https%3A%2F%2Fcdn.hashnode.com%2Fres%2Fhashnode%2Fimage%2Fstock%2Funsplash%2FEJe6LqEjHpA%2Fupload%2Fd5809f666c428b80bcf467df272533b5.jpeg&w=3840&q=75)
These are notes for myself. Use on production database at your own risk I use Liquibase a lot. I can't imagine my work without versioning and controlling my database changes. Don't use SYS to deploy your Liquibase changesets! If I have a simple one-s...
![[Open Source Liquibase] Use super-user (not SYS!) to run Liquibase multi-schema changesets](/_next/image?url=https%3A%2F%2Fcdn.hashnode.com%2Fres%2Fhashnode%2Fimage%2Fstock%2Funsplash%2Fwqp-elwK-Kc%2Fupload%2F1dc973a0d2965141f48c0b45e7297496.jpeg&w=3840&q=75)