--- title: "Liquibase and Flyway: Using Database versioning tools for APEX database projects." description: Examining the tools Flyway and Liquibase to formalise DDL and Data Processes and exploring whether they would add value to ongoing and future APEX development projects. image: https://content.dsp.co.uk/hubfs/network%20server%20room%20with%20computers%20for%20digital%20tv%20ip%20communications%20and%20internet-1.jpeg --- [![DSP From Ground to Cloud](https://content.dsp.co.uk/hubfs/Logos/DSP%20From%20Ground%20to%20Cloud/DSP-Logo-Colour-From-Ground-to-Cloud.svg "DSP From Ground to Cloud")](https://dsp.co.uk) [![DSP From Ground to Cloud](https://content.dsp.co.uk/hs-fs/hubfs/2023/Logos/DSP/DSP-Logo-2019-White-600px.png?width=70&height=72&name=DSP-Logo-2019-White-600px.png "DSP From Ground to Cloud")](https://dsp.co.uk) - Services - Consulting Services - [Oracle](https://www.dsp.co.uk/oracle-consultancy) - [Microsoft](https://www.dsp.co.uk/sql-server-consultancy) - [Google](https://www.dsp.co.uk/google-cloud-consultancy) - [Architecture](https://www.dsp.co.uk/solution-design-and-architecture) - Managed Services - [Oracle Managed Services](https://www.dsp.co.uk/oracle-managed-services) - [SQL Server Managed Services](https://www.dsp.co.uk/sql-server-managed-services) - [OCI Managed Services](https://www.dsp.co.uk/oracle-cloud-infrastructure-managed-services) - [Azure Managed Services](https://www.dsp.co.uk/azure-managed-services) - [On Premise Apps Managed Services](https://www.dsp.co.uk/application-managed-services) - [Cloud Apps Managed Services](https://www.dsp.co.uk/oracle-cloud-applications-services) - Licensing and SAM - [Oracle Licensing](https://www.dsp.co.uk/oracle-licensing-services) - [Software Asset Management](https://www.dsp.co.uk/oracle-software-asset-management-sam) - Application Services - [Application Development](https://www.dsp.co.uk/software-development) - [Application Modernisation](https://www.dsp.co.uk/legacy-software-modernisation) - [Oracle Forms to Oracle APEX](https://www.dsp.co.uk/oracle-forms-to-oracle-apex) - [Application Extensions](https://www.dsp.co.uk/software-customisation) - [Archiving Solutions](https://www.dsp.co.uk/application-archiving-solution) - [Application Hosting](https://www.dsp.co.uk/oracle-apex-hosting-services) - [Development Training](https://www.dsp.co.uk/oracle-apex-training) - Data Science - [AI Strategy](https://www.dsp.co.uk/ai-strategy) - [Responsible AI and Governance](https://www.dsp.co.uk/responsible-ai) - [Agentic AI](https://www.dsp.co.uk/agentic-ai) - [Data Management for AI](https://www.dsp.co.uk/data-management) - [Power BI](https://www.dsp.co.uk/power-bi-services) - [Microsoft Fabric](https://www.dsp.co.uk/microsoft-fabric-services) - [Machine Learning](https://www.dsp.co.uk/oci-machine-learning) - Cloud Migration and Management - [Cloud Readiness and Design](https://www.dsp.co.uk/oracle-cloud-readiness-assessment) - [Migration to Fusion and Cloud Applications](https://www.dsp.co.uk/oracle-cloud-application-modernisation) - [Migration to Cloud Infrastructure](https://www.dsp.co.uk/oracle-cloud-migration) - [Private Cloud](https://www.dsp.co.uk/oracle-private-cloud-services) - [Database@ Hyperscaler](https://www.dsp.co.uk/multicloud-management) - [FinOps and Optimisation](https://www.dsp.co.uk/optimise-oracle-cloud-infrastructure) - Integration and APIs - [API Management](https://www.dsp.co.uk/api-development-services) - [GoldenGate](https://www.dsp.co.uk/oracle-goldengate-services) - Disaster Recovery and Security - [Disaster Recovery](https://www.dsp.co.uk/oracle-database-disaster-recovery-solutions) - [Security Compliance](https://www.dsp.co.uk/data-security) - [Cloud Security](https://www.dsp.co.uk/cloud-security)   ![Oracle Partner, Microsoft Partner and Google Partner](https://content.dsp.co.uk/hubfs/logo-2021/Partner-logos/multiple-vendor/rectangle-2022/Partner-logos-rectangle-Nov21.svg) #### Getting to know us - [About us](https://www.dsp.co.uk/about) - [What we do](https://www.dsp.co.uk/what-we-do) - [Leadership](https://www.dsp.co.uk/dsp-product-leads) - [Careers](https://www.dsp.co.uk/careers) - Technologies - Oracle Cloud Infrastructure - [Oracle Cloud Infrastructure](https://www.dsp.co.uk/oracle-cloud-infrastructure-services) - [IaaS](https://www.dsp.co.uk/iaas) - [PaaS](https://www.dsp.co.uk/paas-security) - Oracle Database - [Oracle Database](https://www.dsp.co.uk/oracle-database-consulting) - [Autonomous Database](https://www.dsp.co.uk/oracle-autonomous-database-services) - [MySQL and Heatwave](https://www.dsp.co.uk/mysql-services) - [Oracle APEX](https://www.dsp.co.uk/oracle-apex-services) - Oracle Engineered Systems - [Oracle Exadata](https://www.dsp.co.uk/exadata-database-service-consultancy) - [Oracle Database Appliance](https://www.dsp.co.uk/oracle-database-appliance) - Oracle Applications - [Oracle Fusion and Cloud Applications](https://www.dsp.co.uk/oracle-fusion-services) - [Oracle E-Business Suite](https://www.dsp.co.uk/oracle-ebs-services) - [JD Edwards](https://www.dsp.co.uk/jd-edwards-services) - [Peoplesoft](https://www.dsp.co.uk/oracle-peoplesoft-services) - [Hyperion](https://www.dsp.co.uk/oracle-hyperion-services) - Microsoft - [SQL Server](https://www.dsp.co.uk/sql-server-consultancy) - [Microsoft Azure](https://www.dsp.co.uk/microsoft-azure-services) - [Power BI](https://www.dsp.co.uk/power-bi-services) - [Microsoft Fabric](https://www.dsp.co.uk/microsoft-fabric-services) - Google - [Google Cloud Platform (GCP)](https://www.dsp.co.uk/google-cloud-partner) - Multicloud and Database Hyperscaler - [Oracle Database@Azure](https://www.dsp.co.uk/oracle-databaseazure-partner) - [Oracle Database@GCP](https://www.dsp.co.uk/google-cloud-machine-learning) - [Oracle Database@AWS](https://www.dsp.co.uk/amazon-web-services-aws) - [Oracle Azure Interconnect](https://www.dsp.co.uk/oracle-microsoft-multicloud) - Open Source Database - [PostgreSQL](https://www.dsp.co.uk/postgresql-services) - [MySQL](https://www.dsp.co.uk/mysql-services) - [MariaDB](https://www.dsp.co.uk/migration-from-mariadb-to-mysql) #### Managed Services - [Oracle Database](https://www.dsp.co.uk/oracle-managed-services) - [SQL Server](https://www.dsp.co.uk/sql-server-managed-services) - [MySQL](https://www.dsp.co.uk/mysql-support) #### Application Services - [Oracle Applications](https://www.dsp.co.uk/oracle-application-cloud-migration) - [Oracle APEX](https://www.dsp.co.uk/oracle-apex-services) - [Microsoft](https://www.dsp.co.uk/microsoft-partnership) - [ISV Services](https://www.dsp.co.uk/isv-support-and-services) #### Cloud Services - [Oracle Cloud Infrastructure](https://www.dsp.co.uk/oracle-cloud-services) - [Microsoft Azure](https://www.dsp.co.uk/microsoft-azure-services) - [Google Cloud Platform](https://www.dsp.co.uk/gcp-database) - [Multi-cloud](https://www.dsp.co.uk/oracle-microsoft-multicloud) #### Data Science - [Machine Learning](https://www.dsp.co.uk/machine-learning-consulting-services) - [Business Intelligence](https://www.dsp.co.uk/business-intelligence-services) - [Artificial Intelligence](https://www.dsp.co.uk/artificial-intelligence-consulting-services) #### Consulting Services - [Oracle](https://www.dsp.co.uk/oracle-consultancy) - [Microsoft](https://www.dsp.co.uk/sql-server-consultancy) - [Google](https://www.dsp.co.uk/google-cloud-consultancy) - [Cloud Migration](https://www.dsp.co.uk/cloud-migrations) #### Technology Solutions - [Engineered Systems](https://www.dsp.co.uk/oracle-engineered-systems-partner) - [Data Security](https://www.dsp.co.uk/data-security) - [Database Architecture](https://www.dsp.co.uk/solution-design-and-architecture) - [Disaster Recovery](https://www.dsp.co.uk/database-disaster-recovery) - Industries - [Finance](https://www.dsp.co.uk/finance) - [Healthcare](https://www.dsp.co.uk/healthcare-it-services) - [Travel and Transport](https://www.dsp.co.uk/database-solutions-for-travel-and-transport) - [Higher Education](https://www.dsp.co.uk/higher-education) - [Public Sector](https://www.dsp.co.uk/public-sector) - [Manufacturing](https://www.dsp.co.uk/manufacturing) - [Retail](https://www.dsp.co.uk/retail) - [Software Vendors](https://www.dsp.co.uk/isv-support-and-services) ### Recent case study: #### Oracle EBS Cloud Deployment Consolidating and Migrating assets into Oracle Cloud Infrastructure. [**![Oracle EBS Cloud Deployment](https://content.dsp.co.uk/hs-fs/hubfs/stonewater-logo%20(1).png?width=250&name=stonewater-logo%20(1).png)**](https://www.dsp.co.uk/stonewater)   #### Most Visited Pages - [Oracle Licensing](https://www.dsp.co.uk/oracle-licensing) - [Oracle Cloud Calculator](https://www.oracle-cloud-calculator.com/) - [Oracle Cloud Migration](https://www.dsp.co.uk/oracle-cloud-migration) - [Oracle Exadata Services](https://www.dsp.co.uk/oracle-exadata-services) - [Artificial Intelligence Services](https://www.dsp.co.uk/artificial-intelligence-consulting-services) #### - - [SQL Server Support](https://www.dsp.co.uk/sql-server-support) - [Oracle Support](https://www.dsp.co.uk/oracle-support) - [Google Cloud Consultancy](https://www.dsp.co.uk/google-cloud-consultancy) - [New Application Development](https://www.dsp.co.uk/oracle-apex-services) - [Azure Virtual Desktop](https://www.dsp.co.uk/azure-virtual-desktop) - Resources - [Gartner ](https://www.dsp.co.uk/complimentary-gartner-download) - [ISG](https://www.dsp.co.uk/isg-oracle-report) - [Blogs](https://www.dsp.co.uk/blogs) - [Case Studies](https://www.dsp.co.uk/case-studies) - [Testimonials](https://www.dsp.co.uk/testimonials) - [Events](https://www.dsp.co.uk/events) - [Webinars](https://www.dsp.co.uk/webinars) - [Insights](https://www.dsp.co.uk/insights) - [Technical Resources](https://www.dsp.co.uk/technical-resources) ### DSP-Explorer acquires leading Oracle Applications Managed Services Provider, Claremont, to further extend its data management capabilities.   [![Read More](https://no-cache.hubspot.com/cta/default/3321273/c7e13c9c-65e1-46e7-8541-8da86a4fc305.png)](https://cta-redirect.hubspot.com/cta/redirect/3321273/c7e13c9c-65e1-46e7-8541-8da86a4fc305) #### Resources - [Blogs](https://www.dsp.co.uk/blogs) - [Webinars](https://www.dsp.co.uk/webinars) - [Case Studies](https://www.dsp.co.uk/case-studies) - [Testimonials](https://www.dsp.co.uk/testimonials) - About - [About DSP](https://www.dsp.co.uk/about) - [What We Do](https://www.dsp.co.uk/what-we-do) - [DSP Group Board ](https://www.dsp.co.uk/dsp-group-board) - [Careers](https://www.dsp.co.uk/careers) - [Project Harar](https://www.dsp.co.uk/project-harar) - [Customer Area](https://www.dsp.co.uk/contact-us) - [Customer Support Portal](https://dspgroup-ism.ivanticloud.com/) - [Customer Resources](https://www.dsp.co.uk/welcome) - [Contact us](https://www.dsp.co.uk/contact-us) # Liquibase and Flyway: Using Database versioning tools for APEX database projects. [ Mike Pickering ](https://content.dsp.co.uk/author/mike-pickering) 28-Jul-2022 13:56:39 ### Contents [30-Apr-2024 13:35:28 The Ultimate Guide to Oracle Database@Azure ](https://content.dsp.co.uk/the-ultimate-guide-to-oracle-databaseazure) [21-Jul-2022 11:41:53 Oracle partners with Microsoft to give Azure customers access to Oracle databases on Oracle Cloud Infrastructure ](https://content.dsp.co.uk/oracle-partners-with-microsoft-to-give-azure-customers-access-to-oracle-databases-on-oracle-cloud-infrastructure) [27-Jul-2022 15:47:32 Do you still have Oracle Database Standard Edition (DBSE) or Database Standard Edition One (DBSE1)? ](https://content.dsp.co.uk/do-you-still-have-oracle-database-standard-edition-dbse-or-database-standard-edition-one-dbse1) As an [APEX ](https://www.dsp.co.uk/oracle-apex-services)developer that used to be an [Oracle Forms](https://www.dsp.co.uk/oracle-forms-to-oracle-apex) developer, my approach to releasing front-end code (APEX apps) and backend code (the plsql packages and triggers that support the application) has always been pretty fixed and clear. You write the application in the builder, export it and save it in version control. You maintain your packages etc in a file in a folder linked to a version-controlled repository and compile the object against the database. The element of Oracle application development that’s always been a little unintuitive for me is the DDL side of things. On one hand, DDL during a dev project will evolve over time in much the same way as business logic in code and therefore can be treated in much the same way. E.g. you make a change to a table, you add a column to the table script in your repo. Alternatively, you make a change to some config data and you create or modify insert/update scripts accordingly. However, for me at least, there’s always been an element of complexity and, for want of a better word, faff, about maintaining scripts in this way. Possibly because unlike maintaining code, the process of updating DML and data is slightly more removed from the main thrust of app development. Changes can easily get lost without good discipline in a multi-developer team, mainly because the act of making the change (e.g. adding a column to a table) requires another step to keep everything up to date, whereas changing (e.g.) a package function is both the functional and scripted change because I simply updated my version script from the repo and compiled it. As such, I did some digging into ways of formalising the DDL and Data processes. I examined a couple of tools – Flyway and Liquibase, to see whether they would add value to ongoing and future APEX development projects. - Both of these tools allow versioned control and deployment of Database schema and data. - Both basic versions are free to use. Additionally, I examined using the integrated version of Liquibase in SQLcl which crucially allows the generation of a baseline version from an existing database. Both tools allow you to version your schema and data changes so that you can track what was changed and when. Both allow you to deploy the latest versions of code to other environments. ## Flyway I downloaded the community, command line version of Flyway from https://flywaydb.org/ and was very quickly able to start generating DDL and creating different migrations for my schema and data. There is a basic folder structure from which you can execute Flyway functions: [![MP_blog_07222_1](https://content.dsp.co.uk/hs-fs/hubfs/MP_blog_07222_1.png?width=263&name=MP_blog_07222_1.png)](https://content.dsp.co.uk/hubfs/MP_blog_07222_1.png) The ‘conf’ folder contains a config file that allows you to set up your database connection, with relevant user/password etc… it helpfully contains the connection string format for most types of database: [![MP_blog_07222_2](https://content.dsp.co.uk/hs-fs/hubfs/MP_blog_07222_2.png?width=602&name=MP_blog_07222_2.png)](https://content.dsp.co.uk/hubfs/MP_blog_07222_2.png) I then created some basic ddl and data files in the ‘sql’ folder: V1__Create_demo01.sql: [![MP_blog_07222_3](https://content.dsp.co.uk/hs-fs/hubfs/MP_blog_07222_3.png?width=316&name=MP_blog_07222_3.png)](https://content.dsp.co.uk/hubfs/MP_blog_07222_3.png) V2__demo01_data.sql: [![MP_blog_07222_4](https://content.dsp.co.uk/hs-fs/hubfs/MP_blog_07222_4.png?width=497&name=MP_blog_07222_4.png)](https://content.dsp.co.uk/hubfs/MP_blog_07222_4.png) I now simply open a command window, navigate to my flyway folder and run ‘flyway migrate’ [![MP_blog_07222_5](https://content.dsp.co.uk/hs-fs/hubfs/MP_blog_07222_5.png?width=257&name=MP_blog_07222_5.png)](https://content.dsp.co.uk/hubfs/MP_blog_07222_5.png) This performs the migration, checking what versions (based on the V… in the file name) have already been installed and installs anything new. [![MP_blog_07222_6](https://content.dsp.co.uk/hs-fs/hubfs/MP_blog_07222_6.png?width=602&name=MP_blog_07222_6.png)](https://content.dsp.co.uk/hubfs/MP_blog_07222_6.png) In my database I now have the simple table created and data inserted. [![MP_blog_07222_7](https://content.dsp.co.uk/hs-fs/hubfs/MP_blog_07222_7.png?width=207&name=MP_blog_07222_7.png)](https://content.dsp.co.uk/hubfs/MP_blog_07222_7.png) The history of migrations is also available to me in the flyway_schema_history table: [![MP_blog_07222_8](https://content.dsp.co.uk/hs-fs/hubfs/MP_blog_07222_8.png?width=602&name=MP_blog_07222_8.png)](https://content.dsp.co.uk/hubfs/MP_blog_07222_8.png) By following the versioning format I can keep adding new files to the project and then deploy (potentially to multiple environments, dev/test etc) as necessary. In order for this to work on a project, there would probably need to be a ‘gatekeeper’ that handles all such scripts and deploys in one go, rather than each developer making their own changes. But if changes are handled in such a way, it does provide a greater level of control and auditing over the process of changing schema objects and data. ## Liquibase The community, command line version of Liquibase follows very similar principles to flyway. They both use a simple script migration process to create migration versions in the target database. Liquibase differs slightly in that rather than creating multiple files, a master ‘changelog’ is used to promote the data, with versioned entries reference within that single file (albeit with the ability to include other files within the master). ### Liquibase – via SQLcl While I was doing some research on Liquibase, a colleague pointed me to the Liquibase capabilities within SQLcl. Up to this point, I was impressed by the ability of Flyway and Liquibase to allow you to create new database projects and develop a method of version control for them, but I hadn’t got to grips with whether it was possible to use such a tool halfway through a project – i.e. get the current state of the database as my ‘V1’ and go from there. The Liquibase capability within SQLcl allows you to do just that, by running commands that export your schema and data into XML files and then redeploying them to another environment as a single version. Obviously being able to do this has potentially massive benefits for the deployment of many different types of projects. Within SCLcl I first brought up Liquibase help: [![MP_blog_07222_9](https://content.dsp.co.uk/hs-fs/hubfs/MP_blog_07222_9.png?width=602&name=MP_blog_07222_9.png)](https://content.dsp.co.uk/hubfs/MP_blog_07222_9.png) This details the various different commands you can use. In this example, I was connected to a database that had an existing schema, that related to an APEX application that had been in use for some time. My task was the move the application/database and data to a newer environment. By running ‘lb genschema’, I was able to generate the entire schema as a series of XML files. In turn, these files were referenced in a file (generated automatically) called controller.xml: [![MP_blog_07222_10](https://content.dsp.co.uk/hs-fs/hubfs/MP_blog_07222_10.png?width=602&name=MP_blog_07222_10.png)](https://content.dsp.co.uk/hubfs/MP_blog_07222_10.png) [![MP_blog_07222_11](https://content.dsp.co.uk/hs-fs/hubfs/MP_blog_07222_11.png?width=538&name=MP_blog_07222_11.png)](https://content.dsp.co.uk/hubfs/MP_blog_07222_11.png) All files are created in the working directory of SQLcl itself. In order to deploy all these objects to a new environment, I simply had to connect to the target environment in SQLcl and run another Liquibase command: lb update -changlog controller.xml (i.e. controller.xml being the migration master file created previously). [![MP_blog_07222_12](https://content.dsp.co.uk/hs-fs/hubfs/MP_blog_07222_12.png?width=602&name=MP_blog_07222_12.png)](https://content.dsp.co.uk/hubfs/MP_blog_07222_12.png) The DDL was then created straightaway in my new environment, complete with logs for each change/file uploaded in the (automatically created) databasechangelog table: [![MP_blog_07222_13](https://content.dsp.co.uk/hs-fs/hubfs/MP_blog_07222_13.png?width=602&name=MP_blog_07222_13.png)](https://content.dsp.co.uk/hubfs/MP_blog_07222_13.png) [![MP_blog_07222_14](https://content.dsp.co.uk/hs-fs/hubfs/MP_blog_07222_14.png?width=602&name=MP_blog_07222_14.png)](https://content.dsp.co.uk/hubfs/MP_blog_07222_14.png)   Database versioning tools such as Liquibase and Flyway offer a powerful solution for maintaining DDL objects and data during development projects. Discipline is, of course, still required: the effectiveness of these products will only be realised if their use is closely controlled. It is therefore a decision point early on in a project in terms of how many resources might be needed to administer these processes vs the gains to the project for doing so. The ability to quickly load schema changes into an environment and keep a record of them is certainly appealing, and being able to snapshot the state of the existing environment gives a very powerful tool for version control and deployment.   If you would like to speak to one of our [Oracle APEX](https://www.dsp.co.uk/oracle-apex-consultancy) experts, get in touch through [enquiries@dsp.co.uk](mailto:enquiries@dsp.co.uk) or book a meeting... [![Book a Meeting](https://no-cache.hubspot.com/cta/default/3321273/3414edc1-fbe5-40fe-9b35-42e662d82b55.png)](https://cta-redirect.hubspot.com/cta/redirect/3321273/3414edc1-fbe5-40fe-9b35-42e662d82b55) [Oracle](https://content.dsp.co.uk/topic/oracle) [APEX](https://content.dsp.co.uk/topic/apex) [Oracle APEX](https://content.dsp.co.uk/topic/oracle-apex) [Liquibase](https://content.dsp.co.uk/topic/liquibase) [Flyway](https://content.dsp.co.uk/topic/flyway) [30-Apr-2024 13:35:28 The Ultimate Guide to Oracle Database@Azure ](https://content.dsp.co.uk/the-ultimate-guide-to-oracle-databaseazure) [21-Jul-2022 11:41:53 Oracle partners with Microsoft to give Azure customers access to Oracle databases on Oracle Cloud Infrastructure ](https://content.dsp.co.uk/oracle-partners-with-microsoft-to-give-azure-customers-access-to-oracle-databases-on-oracle-cloud-infrastructure) [27-Jul-2022 15:47:32 Do you still have Oracle Database Standard Edition (DBSE) or Database Standard Edition One (DBSE1)? ](https://content.dsp.co.uk/do-you-still-have-oracle-database-standard-edition-dbse-or-database-standard-edition-one-dbse1) [Previous Do you still have Oracle Database Standard Edition (DBSE) or Database Standard Edition One (DBSE1)? ](https://content.dsp.co.uk/do-you-still-have-oracle-database-standard-edition-dbse-or-database-standard-edition-one-dbse1) [Next Making informed predictions about Bitcoin with Business Intelligence ](https://content.dsp.co.uk/making-informed-predictions-about-bitcoin-with-business-intelligence) #### Contact Sales Enquiries [+44 (0) 203 880 1686](tel:+4420%2038801686) Technical Support +44 (0) 330 058 8367 [enquiries@dsp.co.uk](mailto:enquiries@dsp.co.uk) #### Follow us #### Office Locations [**London (Head Office)**](https://www.google.com/maps/place/Fora+-+Chancery+House/@51.5174484,-0.1139686,198m/data=!3m2!1e3!5s0x48761adea956397d:0xb7585122cbe86fc0!4m6!3m5!1s0x48761b4b75bf77fb:0x97c4f0ad56af6d23!8m2!3d51.5174586!4d-0.1129066!16s%2Fg%2F11h_cy7xk5?entry=ttu&g_ep=EgoyMDI1MTAwOC4wIKXMDSoASAFQAw%3D%3D) [Chancery House](https://www.google.com/maps/place/Fora+-+Chancery+House/@51.5174484,-0.1139686,19z/data=!3m1!5s0x48761adea956397d:0xb7585122cbe86fc0!4m6!3m5!1s0x48761b4b75bf77fb:0x97c4f0ad56af6d23!8m2!3d51.5174586!4d-0.1129066!16s%2Fg%2F11h_cy7xk5?entry=ttu&g_ep=EgoyMDI1MDkyOS4wIKXMDSoASAFQAw%3D%3D) [53-64 Chancery Lane](https://www.google.com/maps/place/Fora+-+Chancery+House/@51.5174484,-0.1139686,19z/data=!3m1!5s0x48761adea956397d:0xb7585122cbe86fc0!4m6!3m5!1s0x48761b4b75bf77fb:0x97c4f0ad56af6d23!8m2!3d51.5174586!4d-0.1129066!16s%2Fg%2F11h_cy7xk5?entry=ttu&g_ep=EgoyMDI1MDkyOS4wIKXMDSoASAFQAw%3D%3D) [London](https://www.google.com/maps/place/Fora+-+Chancery+House/@51.5174484,-0.1139686,19z/data=!3m1!5s0x48761adea956397d:0xb7585122cbe86fc0!4m6!3m5!1s0x48761b4b75bf77fb:0x97c4f0ad56af6d23!8m2!3d51.5174586!4d-0.1129066!16s%2Fg%2F11h_cy7xk5?entry=ttu&g_ep=EgoyMDI1MDkyOS4wIKXMDSoASAFQAw%3D%3D) [WC2A 1QS](https://www.google.com/maps/place/Fora+-+Chancery+House/@51.5174484,-0.1139686,19z/data=!3m1!5s0x48761adea956397d:0xb7585122cbe86fc0!4m6!3m5!1s0x48761b4b75bf77fb:0x97c4f0ad56af6d23!8m2!3d51.5174586!4d-0.1129066!16s%2Fg%2F11h_cy7xk5?entry=ttu&g_ep=EgoyMDI1MDkyOS4wIKXMDSoASAFQAw%3D%3D) [**Leeds** Richmond House, Lawnswood Business Park, Leeds, LS16 6QY](https://www.google.com/maps/dir/53.8405223,-1.6062773/DSP-Explorer/@53.8404788,-1.6061783,17z/data=!4m9!4m8!1m1!4e1!1m5!1m1!1s0x4879591e5d204ac9:0x4e41b926d72adca!2m2!1d-1.6064847!2d53.8404842) [**Derby**](https://www.google.com/maps/place/Cubo+Pride+Park/@52.9142877,-1.4558952,331m/data=!3m2!1e3!5s0x4879f10728c1eea1:0x877f85530d38bf6!4m15!1m8!3m7!1s0x4879f1072b0e2ebb:0x7c717035ff049b12!2sPride+Pl,+Derby+DE24+8QR!3b1!8m2!3d52.913692!4d-1.4543743!16s%2Fg%2F1th7mf0r!3m5!1s0x4879f16809382b33:0x6fccc05b8500d970!8m2!3d52.914146!4d-1.4544105!16s%2Fg%2F11w4j8v8z2?entry=ttu&g_ep=EgoyMDI1MDYyMi4wIKXMDSoASAFQAw%3D%3D) [Cubo Pride Park,](https://www.google.com/maps/place/Cubo+Pride+Park/@52.9142877,-1.4558952,331m/data=!3m2!1e3!5s0x4879f10728c1eea1:0x877f85530d38bf6!4m15!1m8!3m7!1s0x4879f1072b0e2ebb:0x7c717035ff049b12!2sPride+Pl,+Derby+DE24+8QR!3b1!8m2!3d52.913692!4d-1.4543743!16s%2Fg%2F1th7mf0r!3m5!1s0x4879f16809382b33:0x6fccc05b8500d970!8m2!3d52.914146!4d-1.4544105!16s%2Fg%2F11w4j8v8z2?entry=ttu&g_ep=EgoyMDI1MDYyMi4wIKXMDSoASAFQAw%3D%3D) [1 Pride Place](https://www.google.com/maps/place/Cubo+Pride+Park/@52.9142877,-1.4558952,331m/data=!3m2!1e3!5s0x4879f10728c1eea1:0x877f85530d38bf6!4m15!1m8!3m7!1s0x4879f1072b0e2ebb:0x7c717035ff049b12!2sPride+Pl,+Derby+DE24+8QR!3b1!8m2!3d52.913692!4d-1.4543743!16s%2Fg%2F1th7mf0r!3m5!1s0x4879f16809382b33:0x6fccc05b8500d970!8m2!3d52.914146!4d-1.4544105!16s%2Fg%2F11w4j8v8z2?entry=ttu&g_ep=EgoyMDI1MDYyMi4wIKXMDSoASAFQAw%3D%3D) [Derby](https://www.google.com/maps/place/Cubo+Pride+Park/@52.9142877,-1.4558952,331m/data=!3m2!1e3!5s0x4879f10728c1eea1:0x877f85530d38bf6!4m15!1m8!3m7!1s0x4879f1072b0e2ebb:0x7c717035ff049b12!2sPride+Pl,+Derby+DE24+8QR!3b1!8m2!3d52.913692!4d-1.4543743!16s%2Fg%2F1th7mf0r!3m5!1s0x4879f16809382b33:0x6fccc05b8500d970!8m2!3d52.914146!4d-1.4544105!16s%2Fg%2F11w4j8v8z2?entry=ttu&g_ep=EgoyMDI1MDYyMi4wIKXMDSoASAFQAw%3D%3D) [DE24 8QR](https://www.google.com/maps/place/Cubo+Pride+Park/@52.9142877,-1.4558952,331m/data=!3m2!1e3!5s0x4879f10728c1eea1:0x877f85530d38bf6!4m15!1m8!3m7!1s0x4879f1072b0e2ebb:0x7c717035ff049b12!2sPride+Pl,+Derby+DE24+8QR!3b1!8m2!3d52.913692!4d-1.4543743!16s%2Fg%2F1th7mf0r!3m5!1s0x4879f16809382b33:0x6fccc05b8500d970!8m2!3d52.914146!4d-1.4544105!16s%2Fg%2F11w4j8v8z2?entry=ttu&g_ep=EgoyMDI1MDYyMi4wIKXMDSoASAFQAw%3D%3D) ** [Dublin](https://www.google.com/maps/search/Inniscarra,+Main+Street,+Rathcoole,+Dublin/@53.2810032,-6.4764674,17z/data=!3m1!4b1?entry=ttu)** [Inniscarra,](https://www.google.com/maps/search/Inniscarra,+Main+Street,+Rathcoole,+Dublin/@53.2810032,-6.4764674,17z/data=!3m1!4b1?entry=ttu) [Main Street,](https://www.google.com/maps/search/Inniscarra,+Main+Street,+Rathcoole,+Dublin/@53.2810032,-6.4764674,17z/data=!3m1!4b1?entry=ttu) [Rathcoole,](https://www.google.com/maps/search/Inniscarra,+Main+Street,+Rathcoole,+Dublin/@53.2810032,-6.4764674,17z/data=!3m1!4b1?entry=ttu) [Dublin](https://www.google.com/maps/search/Inniscarra,+Main+Street,+Rathcoole,+Dublin/@53.2810032,-6.4764674,17z/data=!3m1!4b1?entry=ttu) #### About Us DSP is a Data Management and Cloud Platform MSP that delivers enterprise grade support & consulting services for Oracle, Microsoft and Multi-Cloud technologies. ![Oracle Partner](https://content.dsp.co.uk/hubfs/logo-2021/Partner-logos/Oracle-logos/Colour/o-prtnr-cmyk-250.png) ![Microsoft Partner](https://content.dsp.co.uk/hubfs/Microsoft%20partner%20logos%20-%20July%202023/mic-sol-part-colour@200x.png) ![Google Cloud Partner](https://content.dsp.co.uk/hubfs/logo-2021/Partner-logos/GCP-Logos/Google-Cloud-Partner%20(1).svg) Registered Office: 30 City Road, London, EC1Y 2AB. Company Registration Number: 03898451 ```json { "@context" : "https://schema.org", "@type" : "BlogPosting", "dateModified" : "2024-10-01", "datePublished" : "2024-10-01", "headline" : "Liquibase and Flyway: Using Database versioning tools for APEX database projects.", "image" : [ "https://www.dsp.co.uk/hubfs/network%20server%20room%20with%20computers%20for%20digital%20tv%20ip%20communications%20and%20internet-1.jpeg" ], "mainEntityOfPage" : { "@id" : "https://content.dsp.co.uk/liquibase-and-flyway-using-database-versioning-tools-for-apex-database-projects", "@type" : "WebPage" } } ```