| Subject | Re: [firebird-support] Data conversion Firebird to Interbase |
|---|---|
| Author | Helen Borrie |
| Post date | 2009-05-14T08:29:49Z |
At 05:52 PM 14/05/2009, you wrote:
One trick you could *try* (and I haven't) is to rename IB's gbak.exe to something temporary and copy the gbak.exe from your Firebird version into IB's bin directory. Use that gbak under IB 7.1 and see whether it will restore the database. Use the -se switch. Of course, don't restore over the top of an existing database!!! And don't forget to put IB's gbak back again afterwards.
Another route is to get the IBSurgeon Dataguard tools. There's a utility there that can extract everything from one "database-like" structure and write it into a new database. You might also like to look at their rescue utility for restoring from an unrestorable backup. For more info, ask on firebird-tools, please.
./heLen
>We are basing the Vista version of our product on Firebird, and can easily backup data from older XP version based on Interbase and restore them into firebird. However we have a need for backwards compatibility, ie to move data back from our Vista (Firebird) version to our XP (Interbase version). So far all attempts to backup from Firebird and restore under Interbase (7.1) have failed. Has anybody achieved this?It's not likely to be possible. Firebird and InterBase haven't been "the same" at the ODS level for almost 9 years!
One trick you could *try* (and I haven't) is to rename IB's gbak.exe to something temporary and copy the gbak.exe from your Firebird version into IB's bin directory. Use that gbak under IB 7.1 and see whether it will restore the database. Use the -se switch. Of course, don't restore over the top of an existing database!!! And don't forget to put IB's gbak back again afterwards.
Another route is to get the IBSurgeon Dataguard tools. There's a utility there that can extract everything from one "database-like" structure and write it into a new database. You might also like to look at their rescue utility for restoring from an unrestorable backup. For more info, ask on firebird-tools, please.
./heLen