Daniel, this is intriguing. What is your application written in? Any
possibility of 'open sourcing' the update XML routines, etc?

Myles

===========================
Myles Wakeham
Director of Engineering
Tech Solutions Inc.
Scottsdale, Arizona USA
Phone (480) 451-7440
Web: www.techsol.org

> -----Original Message-----
> From: Daniel Rail [mailto:daniel@...]
> Sent: Monday, August 02, 2004 8:35 AM
> To: firebird-support@yahoogroups.com
> Subject: Re: [firebird-support] Looking for some suggestions...Vertical
> market apps
>
> 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)
>
>
>
>
>
> Yahoo! Groups Links
>
>
>
>