Hi,

At August 2, 2004, 12:01, Lester Caine wrote:

> Myles Wakeham wrote:

>> Is there a way to bypass the costs of keeping these update scripts in place,
>> by doing some form of dynamic 'diff' between the databases and making the
>> delta the installation script somehow?

> I would suspect THAT would be a major source of potential corruptions.
> There are commercial tools to do that, but it could get costly.

Not if it's done right. Because, that's how we update our customers,
and it's an in-house application. Basically, the current structure of
the database is stored in an XML file and then we use that XML file to
compare with the customers database and execute the proper DDL
statements. All, dependencies are dealt with depending on the changes
that are required(drop SP/triger and recreate with required changes),
and if there are foreign keys being dropped, then disconnect and
reconnect is done, just to avoid the "object in use" error. Although,
we decied to eliminate the foreign keys and manage them through
triggers.

--
Best regards,
Daniel Rail
Senior System Engineer
ACCRA Group Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.filopto.com)