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
Reply to author
Sign in to reply to author
Forward
Sign in to forward
Delete
You do not have permission to delete messages in this group
Copy link
Report message
Show original message
Either email addresses are anonymous for this group or you need the view member email addresses permission to view the original message
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
Reply to author
Sign in to reply to author
Forward
Sign in to forward
Delete
You do not have permission to delete messages in this group
Copy link
Report message
Show original message
Either email addresses are anonymous for this group or you need the view member email addresses permission to view the original message
to Registry
This sounds good to me and will be helpful during the upgrades. +1.