Subject Re: [firebird-support] How to convert 2.5 to 2.1 database
Author Ann W. Harrison
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.

Best regards,