On 4-8-2015 00:34, 'Neil Pickles' neil.pickles@...
[firebird-support] wrote:

> I’m sure I saw a message on here about how it was possible to backup a
> database from one Firebird/ODS version and restore it to a previous
> Firebird/ODS version. I am trying to convert a Firebird v2.5 database
> using GBAK from v2.1 and then successfully restore it on Firebird v2.1.
>
> Now I tried this and successfully backed up the v2.5 database using GBAK
> from v2.1, but when I came to restoring that gbk on a Firebird v2.1
> system it got 99% of the way through the restore, did all the tables,
> indices and triggers but came up with an error while restoring user
> privileges.
>
> I get the following error message:-
>
> gbak: …
> gbak: restoring privilege for user SYSDBA
> gbak: ERROR:action cancelled by trigger (3) to preserver data integrity
> gbak: ERROR: table/procedure has non-SQL security class defined
> gbak:Exiting before completion due to errors
>
> Is this expected doing what I am doing or do I need to run a different
> command line switch set to accomplish it.
>
> The GBAK restore command line is currently GBAK –R –P 8192 –v –user
> username –password password backup.gbk database.fdb
>

As far as I know it is not possible to downgrade this way from Firebird 2.5:
see http://tracker.firebirdsql.org/browse/CORE-2949
and http://osdir.com/ml/firebird-db/2013-01/msg00106.html

Mark
--
Mark Rotteveel