https://answers.axonivy.com/questions/3574/how-to-execute-some-code-at-ivy-project-deployment-time-for-upgrading-a-database<p>Hi IvyTeam,</p> <p>We have the following situation: we will have to deploy from time to time an Ivy Application. This application defines a database (MS SQL) for storing the application's data. We would like to create/update this database automatically at Ivy Deployment time with an database updating system like Flyway. (With some SQL Scripts CREATE / UPDATE TABLE ....)</p> <ul> <li>Is that already possible with Ivy? Ivy does it already at Ivy Engine installation or upgrade time with its System database. This would be a great feature if we could create/upgrade our project's databases at application deployment time.</li> <li>If not we should be able to execute some code at Ivy deployment time. Is there some Ivy Server Extension points allowing this easily?</li> </ul> <p>Thanks a lot in advance Cheers Emmanuel</p>enThu, 13 Dec 2018 02:43:58 -0500https://answers.axonivy.com/questions/3574/how-to-execute-some-code-at-ivy-project-deployment-time-for-upgrading-a-database/3575<ul> <li>if you just need an updated database schema and you access the DB using JPA you can use the standard schema migrations: <code>hibernate.hbm2ddl.auto=update</code></li> <li>when you have a proprietary stack you can implement an extension point that is triggered at deploy time: <code>ch.ivyteam.ivy.deployment.restricted.IProjectResourceDeployer</code>. But be warned that this an internal extension point and can be changed at any time from our side without notice.</li> </ul>Reguel WermelingerThu, 13 Dec 2018 02:43:58 -0500https://answers.axonivy.com/questions/3574/how-to-execute-some-code-at-ivy-project-deployment-time-for-upgrading-a-database/3575