Subject Re: [firebird-support] Downconverting fdb from 2.5 to 1.5 ?
Author Helen Borrie
At 08:54 a.m. 26/06/2015, srotyliano@... [firebird-support] wrote:

>Is it possible to convert a 2.5 fdb file to 1.5 ?

In the past, it was usually achievable to "go back" one ODS at a time by the following - using 2.1 back to 1.5 as an example --

1. With 2.1 server running, 2.1 to 2.0 - in the 2.1 setup, rename gbak.exe to gbakx.exe then copy gbak.exe from the 2.0 setup into the 2.1. Use that version of gbak to make a transportable backup of the ODS 11.1 database.

2. With 2.0 server running --
a) restore the backup using gbak v.2.0
b) rename gbak.exe to gbakx.exe
c) copy gbak.exe from v.1.5 into the 2.0 setup
d) use that version of gbak to make a transportable backup

3. With 1.5 running restore the backup using gbak v.1.5

Although downgrading has never been supported (and never will be), on the older versions this procedure would usually work. You could try to do the initial downgrade from 2.5 to 2.1 to see whether it's worth attempting the whole trip. I suggest you do a gstat -h on each restored database to check the ODS version. 2.5: ODS 11.2, 2.1: ODS 11.1, 2.0: ODS 11.0, 1.5:ODS 10.1.

If you don't have old versions archived, you can pick up the newest sub-releases of each as zip or compressed tar files (acc. to your platform) from the Downloads section of the website and extract the gbak executables.

Helen Borrie, Support Consultant, IBPhoenix (Pacific)
Author of "The Firebird Book" and "The Firebird Book Second Edition"