Hello Steve,

> > 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.

Well, that depends on your connectivity library... And on how you're
connecting.

Database Workbench, for example, is able to use both "gds32.dll"
and "fbclient.dll" ... It has separate modules for InterBase and Firebird
and it includes a DataPump tool.

www.upscene.com


With regards,

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Server
Upscene Productions
http://www.upscene.com
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com