Subject | Re: [IBO] update a database with structure / triggers / ect.. |
---|---|
Author | Dany M |
Post date | 2006-07-07T09:35:15Z |
AFAIK IBO does not have an automated routine for this. There is,
however, Script handling in IBO. Scripts are a series of SQL statements.
There are tools out there that will take one database, compare all the
metadata to a second one and produce a script that will update the
second one to match the first. The tool you select should be smart
enough to issue statement in the correct order regarding forreign keys
and dependencies and to issue COMMITS and DISCONNECT/CONNECT to make
everything work even with advanced and convoluted updates. The tool
should also take in account the version of FB/IB you are using.
Personally I use IBExperts build in function.
HTH,
/Dany
ronald_greven wrote:
however, Script handling in IBO. Scripts are a series of SQL statements.
There are tools out there that will take one database, compare all the
metadata to a second one and produce a script that will update the
second one to match the first. The tool you select should be smart
enough to issue statement in the correct order regarding forreign keys
and dependencies and to issue COMMITS and DISCONNECT/CONNECT to make
everything work even with advanced and convoluted updates. The tool
should also take in account the version of FB/IB you are using.
Personally I use IBExperts build in function.
HTH,
/Dany
ronald_greven wrote:
> Hi there,
>
> I use Delphi5, Firebird 1.0/1.5 (both) and IB_Objects.
>
> We have a reference Database, where we develop. Each time, we edit one
> or more stored procedures / trigger / data structure we have to update
> the database, which is installed by our customers.
>
> At the moment we do this manually.
>
> Is there a easier way to do this automatically (maybe with an own
> update application)?
>
> I know, that I could get all the informations from the RDB$Systemtables.
>
> If yes (and I am sure that it works somehow) which components do I
> have to use?
>
> Best greetings..
>
> Ronni
>
>
>
>
>
>
>
> ___________________________________________________________________________
> IB Objects - direct, complete, custom connectivity to Firebird or InterBase
> without the need for BDE, ODBC or any other layer.
> ___________________________________________________________________________
> http://www.ibobjects.com - your IBO community resource for Tech Info papers,
> keyword-searchable FAQ, community code contributions and more !
> Yahoo! Groups Links
>
>
>
>
>
>