RE: Informix to Oracle conversion

I work with Informix. And not afraid to admit it. ;-) I'm just getting started with Oracle and haven't done any conversions yet but I see it pretty much a slam-dunk, excluding stored procedure and trigger rework of course.

You can use Informix's dbaccess, or isql if you have that. Either one is sufficient enough to unload your data to files that Oracle can load from.   unload to "filename"
  select * from tabname
will create a pipe delimited file. You can delimit with anything you want.

dbaccess is the equivalent to sqlplus, only much better in my opinion.

I gotta tell you guys, I feel like I'm selling my sole with a move to Oracle. That saying that you like what you know and hate everything else has it's truth. But I can say now that even after giving me a couple more years on Oracle, I'll still say that Informix is better than Oracle! Oracle has a couple of little things they do better, from what I've seen so far, but I think the only big thing they do better is Marketing! But hey, that's where the bucks are. I'm sold. ;-)

Don.

-----Original Message-----
From: James Howerton [mailto:jhowerton_at_uabmc.edu] Sent: Tuesday, September 12, 2000 3:45 PM To: Multiple recipients of list ORACLE-L Subject: RE: Informix to Oracle conversion

Bill,

The help I need is not really with the kit but with just a few Informix basics. I have never worked with Informix and there is nolonger anyone here that has either(or won't admit to it anyway). The scripts supplied by the Oracle kit use dbadmin to interface with the database. I have no clue how to use this product and I'm running it against a production system. Do I need to logon as the Informix UNIX user and then run dbadmin? When I run it as annother user I get not connected errors, here is an example of the run    

   " dbaccess database_name script.sql"

Is there anything resembling sqlplus available for interacting with the database?

Thanks

...JIM...
>>> wcarle_at_att.com 9/12/00 12:34:13 PM >>>
I have done an Informix to Oracle conversion, but I'm not sure what the Oracle conversion kit is. I wrote my own conversion.

Bill Carle
AT&T
Database Administrator
816-995-3922
wcarle_at_att.com

 -----Original Message-----

Sent:	Monday, September 11, 2000 4:51 PM
To:	Multiple recipients of list ORACLE-L
Subject:	Informix to Oracle conversion

DBA's

Has anyone done an Informix to Oracle conversion? I need a little help to get started with the Oracle conversion kit. Please contact me off list.

Thanks

Jim Howerton
jhowerton_at_uabmc.edu

-- 
Author: James Howerton
  INET: jhowerton_at_uabmc.edu 

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Author: Carle, William T (Bill), NBSO
  INET: wcarle_at_att.com 

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

-- 
Author: James Howerton
  INET: jhowerton_at_uabmc.edu

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may