Sándor Tamás (HostWare Kft.) wrote:

>>>Full database update? What's that?
>
> That means, we create an empty database structure, and pump the old
> database's datas into this new one.
>
>>>Running a bunch of ALTER TABLE ADD FOREIGN KEY statements should do the
>>>job. It isn't much complicated to write a tool that would use the info
>>
>>>from system tables to drop all FKs and recreate them later. Which
>>
>>>programming language do you use to access Firebird?
>
>
> In fact this is what we are using. Drop all FKs, and then recreate them with
> a full database update.

You don't need to pump the data. You can create FKs on the same database
where you dropped them.

--
Milan Babuskov
http://fbexport.sourceforge.net
http://www.flamerobin.org