In order to do an automatic migration from Firebird to Oracle the only fully automatic process for Tables and Data is make a 2-step migration:
– Firebird to MySQL with MySQL Migration tool
– MySQL to Oracle with SQL Developer Migration Workbench
..but first:

Firebird connection through JDBC on Windows

I downloaded Firebird 1.5 which comes with a demo database Employee.fbd.
After this I downloaded SquirrelSQL, a cross-platform open-source JavaSQL Client which uses JDBC connection to a large number of databases. Firebird is one of them and as long as Firebird comes just with a console application, I found SquirrelSQL very useful.

1. Install JDK into a convenient location, preferred C:\Java in order not to use spaces in the path.2. Copy JayBird jar file to C:\Java\lib or add it to the CLASSPATH environment variable3. Add jaybird21.dll to system path (I copied it to the system32 folder).4. Start SquirrelSQL and try to connect to the Firebird JayBird driver in the drivers pane until it will appear with a blue check icon.5. The class name should be org.firebirdsql.jdbc.FBDriver and make sure that jaybird jar file is present into the Java Class path. If it’s blue then means that the driver is active and we can test it.6. We should first create a new alias for employee database in the Firebird aliases.conf file. After creating such an alias, the connection string should be “jdbc:firebirdsql:localhost/3050:employee”, username/password are sysdba/masterkey (default ones). 7. You are connected. you will see the objects list, data, DDL, whatever you need.

This entry was posted on Wednesday, November 26th, 2008 at 12:44 pm and is filed under Database, Oracle.You can follow any responses to this entry through the RSS 2.0 feed.You can leave a response, or trackback from your own site.

2 Responses to “Migrate from Firebird to Oracle step by step – Part 1”

[...] we tested our JDBC connection to Firebird and then migrated from Firebird to MySQL we have just one more step to [...]

Leave a Reply

Name (required)

E-mail (will not be published) (required)

Website

Search

About me.

I am Senior Technologist for Oracle Corp., delivering workshops, presentations and working in projects for EMEA partners. I have a degree in Software Engineering and own OCP DBA, OCP Dev and MCSD certifications.