Subject | RE: [firebird-support] Converting Interbase Database to Firebird |
---|---|
Author | Leyne, Sean |
Post date | 2005-08-24T03:06:03Z |
Steve,
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.
Sean
> I need to convert an Interbase v7.1 database to Firebird v1.52. I didI would urge you to use a different approach.
> 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?
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.
Sean