Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Converting dBase files
I believe any such conversion will require going through ODBC, which
introduces some limitations, especially with the dBase MEMO datatype. ODBC
has a 254 character per field limitation.
That being said, I've used Lotus Approach (which uses ODBC) many, many times to convert from dbase III and IV to Oracle. The table definitions do get transferred as well, but again, there are some limitations. For example, dBase text fields become VARCHAR2 in Oracle (which in most cases is a good thing) as opposed to CHAR. The biggest problem is that the column and table names become case-sensitive during the translation, so be sure that all of these are in all UPPER CASE. One advantage to Approach is that you can join dBase and Oracle tables. This will aid during the data migration, especially if you have memo fields. If you decide to go with Approach, contact me for further details.
I suppose you could also use Data Junction, but I've had problems with it, and found it much more difficult to use than Approach. There may be other tools available- I don't know.
"Chris" <schnul_at_my-deja.com> wrote in message
news:849r1i$glu$1_at_nnrp1.deja.com...
> Hi there!
>
> Probably this is an often asked and easy question for most of you,
> but...
>
> I am new to Oracle. I use Oracle8i Lite and I need to convert some
> files from dBase to Oracle. Is there an easy way to convert these files
> from dBase to Oracle, so that also the table definitions are converted
> automatically?
>
> Thx in advance,
> Chris
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Tue Dec 28 1999 - 11:35:18 CST