we have requirement to automate the DB changes (schema change, procedures and triggers) whenever we release the new version of Application with DB changes.
What is the best way to achieve this ?
Thanks in advance...
I don't claim to know about the "best way". But what we do is using PowerDesigner to change the "Model" and generate matching update scripts for each release of our software.
answered 03 Sep '12, 08:19
We also have a external application to model our databases. We have a table where we store the version number of the database model.
Our application on startup then checks if the version is identic to the expected one. If not, we then apply all the steps as sql commands needed to get a current schema.
In the same step we can also migrate/transform data as required. The code also allows us to define if a failed action is fatal for the migration process or not.
answered 03 Sep '12, 09:41