Convert SQLBase to Oracle 11g

[evititoe]

First, let me start off by saying that I am NOT a SQL person. I am a technician with over a decade of experience, though. That being said...

I have a customer who is upgrading their backend software. Let me rephrase that... "I" am upgrading their backend software. The current software utilizes SQLBase 8, but the newest version isn't compatible with SQLBase at all. So, I need to migrate the data from SQLBase to Oracle 11g.

Is there an automated way of migrating? Or, at least, a fairly simple way?

Any help is much appreciated.

[Mike Vandine]

No real easy way that I know of.

If you're just trying to get the data, I would set up an ODBC link for SQLBase and then extract all the data into a comma-separated flat file (using EXCEL, etc.) then import that into the Oracle database. You will probably have problems if you use Long Varchars, etc.

Good luck!

[FRBhote]

There used to be a paper on the Oracle website regarding migration. If your database is not too big, a simple unload of sqlbase and run the output file on oracle should do it.