Need to migrate an application from Blackfish to Firebird

What is the effort to migr开发者_如何转开发ate from Blackfish to Firebird ?

I use DBX4

No stored procedure, or function or views

I access all my data trough SQL queries

---

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.

---

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

---

For database pumping you can use tools like :

IBExpert (full version)

Database Workbench (full version)

or database comparer