Hi,

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...

vhm

asked 31 Aug '12, 06:32

vhm's gravatar image

vhm
210131320
accept rate: 0%

edited 05 Sep '12, 09:08

Volker%20Barth's gravatar image

Volker Barth
40.1k361549819


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.
PowerDesigner (Physical Model) is included as a utility in the SQL Anywhere product, so we tried it before looking at other solutions and stayed with it since then.

permanent link

answered 03 Sep '12, 08:19

Reimer%20Pods's gravatar image

Reimer Pods
4.5k384891
accept rate: 11%

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.

permanent link

answered 03 Sep '12, 09:41

ASchild's gravatar image

ASchild
777222740
accept rate: 14%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×53
×38
×25
×23

question asked: 31 Aug '12, 06:32

question was seen: 2,211 times

last updated: 05 Sep '12, 09:08