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 - http://lsces.co.uk/wiki/?page=contact
L.S.Caine Electronic Services - http://lsces.co.uk
EnquirySolve - http://enquirysolve.com/
Model Engineers Digital Workshop - http://medw.co.uk//
Firebird - http://www.firebirdsql.org/index.php