The search term you need is 'data pump'. For example, check out Clever Components - Interbase DataPump http://www.clevercomponents.com/products/datapump/index.asp http://www.clevercomponents.com/products/datapump/index.asp Clever Components - Interbase DataPump http://www.clevercomponents.com/products/datapump/index.asp Version 3.4 (4 November 2002) Release View on www.clevercomponen... http://www.clevercomponents.com/products/datapump/index.asp Preview by Yahoo . It's free and can connect to both Interbase/Firebird and any database that has an ADO/ODBC driver, including MSSQL and Oracle. You'll need a working server to connect to, but if the application is functional right now, you probably have that (unless it uses Firebird Embedded). Otherwise you need to look into setting up a Firebird server with the existing database.
If you don't want to pump data directly from one database into the other, and would prefer a readable intermediate step, you could export tables one by one to CSV or XML. For that, have a look over here: How to export data from database and import into another? http://www.firebirdfaq.org/faq86/ How to export data from database and import into another? http://www.firebirdfaq.org/faq86/ Collection of answers to questions about Firebird import, export, database, offline, xml, csv, data, nested. View on www.firebirdfaq.org http://www.firebirdfaq.org/faq86/ Preview by Yahoo .
