Categories
Database Development

Deploying Oracle ADW Changes from development environment to production

I’m currently running an Oracle Autonomous Data Warehouse and have been making changes to my database schema as follows:

  1. Change schema on the development environment using SQL statements (CREATE, ALTER, etc)
  2. Test the development environment manually
  3. Change the schema on the production environment using identical SQL statements
  4. Test the production environment to make sure nothing is broken

I am aware that this is not the way it should be done, we need to implement some CI/CD to streamline these changes but we’ve only recently come out of our piloting phase where it was a rush to get the product working etc, I’m very keen to firm up our new systems.

How I’m imagining it’d go (changes in bold):

  1. Change schema on the development environment using SQL statements (CREATE, ALTER, etc)
  2. Test the development environment with automated tests
  3. Apply some tool to apply the same changes to my production system
  4. Test the production environment to make sure nothing is broken

I have seen that tools exist for other SQL database tools, such as MySQL, PostgreSQL etc but from my searches on Oracle-specific tools, I’m not sure if where to find a tool that can propagate the schema changes from our development database to a production database.

If you know of any tools that I can look at to do this functionality then I’d appreciate a pointer on where to look!

I’m aware this is similar to other questions, the ones I’ve looked at are:

Both of these questions were asked several years ago and so I’m not sure if new things have come up recently.

Thanks,

Ash

Leave a Reply

Your email address will not be published. Required fields are marked *