From the course: Advanced SQL for Application Development
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Automated schema migration with Liquibase
From the course: Advanced SQL for Application Development
Automated schema migration with Liquibase
- [Instructor] Another tool for automating database schema changes and migrations is called Liquibase. Now Liquibase is available at liquibase.org. And it too is a version control system for database schemas. Now, unlike Flyway, which requires that you script your changes in SQL, Liquibase can do that. You can support, use SQL, but you can also use more abstract specifications that are written in XML, JSON or YAML. Those XML, JSON, and YAML specifications will then be used to generate database specific SQL. And that's really nice if you're working with multiple databases. So for example, if you have an application that you want to be able to run on top of Postgres, and SQL Server and MySQL, then using something like Liquibase, and specifying your changes in YAML will help you avoid any database specific SQL issues with your migration scripts. Now Liquibase uses a couple of mechanisms that are important to understand.…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.