Re: How to manage the versions of databases ?

One suggestion is that you make your upgrades in the form of a build script. A single script that when run from SQL*Plus makes all necessary changes. That is the method I have employed and the one used by a number of vendors. If your upgrade code is too large to fit in a single script then write a driver script that calls other scripts in sequence.

Daniel A. Morgan

Nicolas Ecarnot wrote:

> Hello,
>
> In my company, we sell a huge software that uses huges databases, and we
> modify the scheme of the databases almost every 3 months.
> This is very complex to manage for our customers, and we have to manually
> make big changes in their databases.
>
> We are looking for a way to manage rightly these updates, and we already
> have some ideas, but we can't imagine being the first company to deal with
> that hard problem.
>
> So may you give us some URL pointers to web pages explaining how it's
> usually done, or explain us the theory of updating a database model.
> I suppose that some tools exists, so perhaps you know one of these tools.
>
> Thank you in advance.
>
> --
> Nicolas Ecarnot | E-mail: nicolas.ecarnot_at_bigfoot.com
Received on Sat Feb 10 2001 - 06:40:41 CET