Subject Re: Converting Interbase Database to Firebird
Author Steve Harp
--- In firebird-support@yahoogroups.com, "Leyne, Sean" <Sean@B...> wrote:
> Steve,
>
> > I need to convert an Interbase v7.1 database to Firebird v1.52. I did
> > a backup (gbak) of the IB database using IB and restored it using FB
> > using the same user needed to run the application. Is there anything
> > else I need to do?
>
> I would urge you to use a different approach.
>
> Although the database backup files are compatible, and as such gbak
> doesn't report an error, there are difference between IB (especially IB
> v6.5+) and FB which make using backup/restore ill-advised.
>
> I would have you extract the database metadata to a script, use the
> script to generate an empty FB database and then use a datapump tool
> (there are a number of free tools available) to move the data from IB to
> FB.

Can you recommend a tool? I've looked at IBPhoenix and they show
several but none seem to pump from Interbase to Firebird; they seem to
be for pumping from some other database (Pdox, dBase, Access, etc)
into Interbase or Firebird. From what I understand from Helen, it's
not possible to connect to both Interbase and Firebird from the same
application. Of course, I may have misunderstood what she wrote.

Steve