Andrei DANEASA

well… my colleagues from SQL Dev team will probably take out from the marketplace our competition. Having so many features for free is something that me and all the users are highly appreciating.

SQL Developer 2.1 EA1

Some facts of SQL Developer 2.1 Early Adopter 1: Read the rest of this entry »

After we tested our JDBC connection to Firebird and then migrated from Firebird to MySQL we have just one more step to do:

Migration from MySQL to Oracle using SQL Developer Migration Workbench

For migrating MySQL to Oracle we need to have:

• Oracle Database XE (small footprint, free version of Oracle DB)
• SQL Developer

Read the rest of this entry »

Now that we connected successfully to Firebird through JDBC, let’s see if MySQL Migration Tool can connect and migrate the data to MySQL, our intermediary stage for migrating to Oracle.

Migration from Firebird to MySQL

In addition to what we installed during Part 1, we need to install MySQL 5.0 Community Server, the free version, which comes by default (not the Essential Edition) with MySQL Migration Toolkit.
Read the rest of this entry »

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

Read the rest of this entry »

As I had a request and I must agree it really makes sense, I developed a console version of the DBF2Oracle tool. Functionality is the same, just that you need to give it parameters from command line.

Usage is:

Read the rest of this entry »

UPDATE 2008-11-05! A console version is available here

Since I had more and more requests for DBF migrations to Oracle and SQL Developer offers no support for DBF migrations, I decided to make a tool to ease my work. There used to be a command prompt tool (ImpDBF.exe) which generates the equivalent table for Oracle and SQL*Loader scripts for importing the data. This tool was for Oracle 7 and 8 and I don’t have the source code for this tool.

The workaround was to create a frontend for that tool that can also fix problems in generated files.
The result is the like this:

Read the rest of this entry »