Jump to content
Henry Olive

From Interbase To Firebird

Recommended Posts

I have an Interbase 2007 database and i'd like to move to Firebird 3,0

Is there any to Database Management Tool that can transfer ALL metadata & datas

from IB to Firebird w/o any headache ?

Thank You

Share this post


Link to post

Hi,

In the old days a simple backup (transportable format) from Interbase, and restore in Firebird works, but I don't know if this solution works now.

Share this post


Link to post

Since the IB version has some mileage, i would definately try to make a gbak backup (transportable) and try to restore it in FB 3.0.

Otherwise i suspect som isql scripting for the metadata and some home-made transfer app.

Share this post


Link to post
Guest
Posted (edited)

IBExpert or same FireDAC

Connect IB 

Connect Firebird

just commands to "create" new structure on FB if not exist

now do the SELECT  on IB and UPDATE to FB

or use generate a script w IB data and update FB table

if have a IBExpert Pro many others ways

 

Interbase x Firebird --->  ODS differences

Edited by Guest

Share this post


Link to post
1 minute ago, emailx45 said:

if have a IBExpert Pro many others ways

Agreed, IBExpert have a lot of nifty tools built-in. But the price man! No "single dev" licence, one per machine 😞

Share this post


Link to post
Guest

try IBConsole w 2 connectionDB

Share this post


Link to post
Posted (edited)
On 1/2/2021 at 4:14 PM, emailx45 said:

now do the SELECT  on IB and UPDATE to FB

How about metadata (access rights) , triggers etc?

Edited by A.M. Hoornweg

Share this post


Link to post

I'd extract metadata as SQL and try to create DB from it, then use DataPump to transfer data

Share this post


Link to post

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×