<html><head><meta http-equiv="Content-Type" content="text/html charset=utf-8"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;" class=""><div class="">DBAs don’t like applications modifying the database schema on startup. They want scripts they can review. It’s a bit silly in some ways and I do not think it’s cause for alarm or to move off Liquibase though. Liquibase really simplifies things a lot and it can generate a SQL script to be applied before application startup: <a href="http://www.liquibase.org/documentation/sql_output.html" class="">http://www.liquibase.org/documentation/sql_output.html</a></div><div class=""><br class=""></div><div class="">As long as Keycloak will run the Java migration code if the DB is updated offline, it should be fine.</div><div class=""><br class=""></div><div class="">There should be some documentation on upgrading in the user guide. It would be worth documenting the correct way to upgrade, especially if you’re running a cluster or multiple standalone servers sharing a database. I am pretty sure you can’t do a rolling upgrade but someone may try it. ;)</div><br class=""><div apple-content-edited="true" class="">
<div class="">Scott Rossillo</div><div class="">Smartling | Senior Software Engineer</div><div class=""><a href="mailto:srossillo@smartling.com" class="">srossillo@smartling.com</a></div><div class=""><br class=""></div><div class=""><a href="https://app.sigstr.com/uc/55e5d41c6533390d03580000" id="campaignblock" target="_blank" style="box-sizing: border-box; color: rgb(0, 75, 118); outline-offset: -2px; font-family: gesta, Arial, Helvetica, sans-serif; font-size: 14px; line-height: 20px; widows: 1; background-color: rgb(255, 255, 255); outline: 0px !important;" class=""><img alt="Latest News + Events" border="0" src="https://app.sigstr.com/uc/55e5d41c6533390d03580000/img" style="box-sizing: border-box; border: 0px; vertical-align: top; max-width: 100%; height: auto; width: inherit; color: blue; font-family: Helvetica; font-size: 12px;" class=""></a><span style="color: rgb(169, 169, 169); font-family: gesta, Arial, Helvetica, sans-serif; font-size: 14px; line-height: 20px; widows: 1; background-color: rgb(255, 255, 255);" class=""></span><div id="watermark" style="box-sizing: border-box; color: rgb(169, 169, 169); font-family: gesta, Arial, Helvetica, sans-serif; font-size: 14px; line-height: 20px; widows: 1; background-color: rgb(255, 255, 255);" class=""><a href="http://www.sigstr.com/" style="box-sizing: border-box; color: rgb(0, 124, 194); text-decoration: none; background-color: transparent; outline: 0px !important;" class=""><img alt="Powered by Sigstr" border="0" src="https://app.sigstr.com/uc/55e5d41c6533390d03580000/watermark" style="box-sizing: border-box; border: 0px; vertical-align: top; max-width: 100%; height: auto; width: inherit; color: rgb(99, 99, 99); font-family: Helvetica; font-size: 11px;" class=""></a></div></div>
</div>
<br class=""><div><blockquote type="cite" class=""><div class="">On Sep 24, 2015, at 3:06 PM, Bill Burke <<a href="mailto:bburke@redhat.com" class="">bburke@redhat.com</a>> wrote:</div><br class="Apple-interchange-newline"><div class="">An interesting suggestion from a user<br class=""><br class="">On 9/24/2015 2:58 PM, Walker, Charles wrote:<br class=""><blockquote type="cite" class="">* move away from liquibase to manage the database schema. it's a nice<br class="">tool but i haven't ran into many dba's that allow an application to<br class="">"alter" the database. that meant i just had to go figure out another<br class="">technology just to tease the sql out of it<br class=""></blockquote><br class="">I'm not sure how we could move away from liquibase. We would have to <br class="">provide a set of SQL scripts (cross-platform too) that would have to be <br class="">run on your database to upgrade keycloak. Then there is the Java-based <br class="">migrators that run after this to message the data with any new <br class="">transformations.<br class=""><br class=""><br class=""><br class="">-- <br class="">Bill Burke<br class="">JBoss, a division of Red Hat<br class=""><a href="http://bill.burkecentral.com" class="">http://bill.burkecentral.com</a><br class="">_______________________________________________<br class="">keycloak-dev mailing list<br class="">keycloak-dev@lists.jboss.org<br class="">https://lists.jboss.org/mailman/listinfo/keycloak-dev<br class=""></div></blockquote></div><br class=""></body></html>