Supporting registry schema versioning and programmatic upgrade with a framework like liquibase

22 views
Skip to first unread message

Saravanan Raju

unread,
Jul 25, 2017, 4:00:20 AM7/25/17
to Registry
Currently, all the necessary schema migrations are kept in one file and it is entirely composed of "create" statements. Instead of this approach, if we should consider breaking down each SQL statements into their respective files and use a framework like liquibase to do SQL migration. With this approach, any new changes that have to be introduced to the SQL entities could be versioned and could be applied on top of an existing database depending upon how far behind the existing database from the latest version.

Harsha Chintalapani

unread,
Jul 25, 2017, 11:14:02 PM7/25/17
to Registry
This sounds good to me and will be helpful during the upgrades. +1.
Reply all
Reply to author
Forward
0 new messages