Subject Re: [firebird-support] How to convert 2.5 to 2.1 database
Author Lester Caine
Ann W. Harrison wrote:
> Ivan Prenosil wrote:
>> "Ann W. Harrison" wrote:
>>> Mr. John wrote:
>>>> Hi. Sorry if this is a silly question,but I need the
>>>> convert 2.5 database to 2.1,thanks for any information.
>>> Another approach is to copy the gbak.exe from the 2.1
>>> kit and use it to backup the database with the 2.5 server.
>>> Copy the backup to a 2.1 system and restore it there,
>>> using the 2.1 gbak again.
>> It does not work for me, I get error during restore
>> gbak: ERROR:action cancelled by trigger (3) to preserve data integrity
>> gbak: ERROR: table/procedure has non-SQL security class defined
> Oh, that's unfortunate. I wonder how the ISQL metadata extract avoided
> that problem. Backward migration with gbak is a useful function,
> particularly for the next release where the engine won't hand multiple
> ODS formats.

Having had to rely on the gbak 'trick' a few times now where sites had to remain
on FB1.5 but the new work is in FB2 then I would say that SOME means of
backwards compatibility is essential?

Lester Caine - G8HFL
Contact -
L.S.Caine Electronic Services -
EnquirySolve -
Model Engineers Digital Workshop -
Firebird -