Need to migrate an application from Blackfish to Firebird

Question

What is the effort to migrate from Blackfish to Firebird ?

I use DBX4

No stored procedure, or function or views

I access all my data trough SQL queries

delphi 2007, but I will upgrade at the end of 2011, to what ever new version. — Jlouro, Jan 30 '11 at 15:02
So DBX4 driver for firebird will be in the box (start with delphi 2010) — Hugues Van Landeghem, Jan 30 '11 at 16:55

score 3 · Answer 1 · answered Jan 30 '11 at 23:03

If you don't rely on specific Blackfish features (SP, trigger, admin packages calls etc), the change should not be a pain.

I've did this kind of migration in a DEMO for a customer.

If you have used Blackfish as a "collection of tables accessible via SQL" then the change will not be difficult at all.

score 2 · Accepted Answer · answered Jan 30 '11 at 14:25

2

There is a driver for delphi and dbx4 firebird http://sites.google.com/site/dbxfirebird/

my guess is that is easy for you to dump the blackfish tables into csv and then to import them in firebird and later modify only the application to access the firebird db using the dbx4 firebird settings

answered Jan 30 '11 at 14:25

Mariuz

1,190
2
10
19

I just care about the code effort. The data migration I dont see any problems, cvs, or other method. – Jlouro Jan 30 '11 at 15:11

score 1 · Answer 3 · answered Jan 30 '11 at 16:58

1

For database pumping you can use tools like :

IBExpert (full version)

Database Workbench (full version)

or database comparer

answered Jan 30 '11 at 16:58

Hugues Van Landeghem

6,755
3
34
59

Need to migrate an application from Blackfish to Firebird

3 Answers3