Convert SQLBase to Oracle 11g

General discussion forum about all databases other than SqlBase.

Convert SQLBase to Oracle 11g

Post by evititoe » 17 Nov 2011, 02:56

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

Re: Convert SQLBase to Oracle 11g

Post by Mike Vandine » 17 Nov 2011, 06:36

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!

Posts: 2201
Joined: 09 Mar 2017, 05:32
Location: Hyderabad, India

Re: Convert SQLBase to Oracle 11g

Post by FRBhote » 17 Nov 2011, 06:43

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.

Return to “General Discussion”

Who is online

Users browsing this forum: [Ccbot] and 0 guests