Re: DBF to Oracle

Erwin will do it, DataJunction will do it. DataJunction actually has a downloadable demo. Erwin is easier I think.

No matter how you do it, it's not as trivial a task as it seems. There are always considerations (memo fields, field names, types, etc..)

HTH, Yosi

Hasam172 wrote:

> There is hope for you and you don't have to fall in love with me either
> :-P
> With SQL Server 7.0 (from the "evil empire" MS) there is a migration
> tool call DTS
> (Data Transformer Services), which you can bring Oracle's datafiles
> over and convert
> it into (guess what?)...Microsoft's tables/index/view, etc...
> You can order a demo (120 days) CD for a few bucks and check it out.
> It's very sleek
> and I called this is a Trojan horse from the "evil empire".
>
> Best of luck (You'll need it).
>
> Sam
>
> Pete Sharman wrote:
> >
> > Bonnie
> >
> > Hate to burst the bubble of possible hope here, but the DBF to Oracle utility
> > Bert is probably after is one to convert data from another database to Oracle
> > (DB4 or something like that).
> >
> > Pete
> >
> > "D. O'Shea" wrote:
> >
> > > Bert if you know of any tool that will allow me to extract data in ANY
> > > form from an oracle dbf file, I would be in love with you. I have an
> > > inaccessible dbf file whihc holds important data that I need really
> > > bad! I have no backup of the rest of the dbf files which make up the
> > > database so I cannot reconstruct it, It sits on UNIX but any tool,
> > > unix or pc wpuld be great. Please e-mail me with anything!
> > >
> > > Bonnie O'Shea
> > >
> > > On Sat, 3 Jul 1999 01:20:26 +0200, "Bert Vanderstraeten"
> > > <bvds_at_hotpop.com> wrote:
> > >
> > > >Does anybody have any ideas on how to import a DBF file into an oracle
> > > >table? I am using a small tool that converts the DBF file to plain ascii and
> > > >loads it into oracle using SQL*Loader but which takes very long.
> > > >
> > > >I heard about a tool called dbf2ora to load dbf's directly into the database
> > > >but as far as I know it only exists for unix, or is there a PC version as
> > > >well?
> > > >
> > > >Kind regards,
> > > >
> > > >Bert Vanderstraeten
> > > >
> > > >
> >
> > --
> > Regards
> >
> > Pete
> >
> > ------------------------------------------------------------------------
> >
> > Pete Sharman <psharman_at_us.oracle.com>
> > Project Manager
> > Oracle University, Consulting and Vertical Education
> > Oracle Corporation
> >
> > Pete Sharman
> > Project Manager

> > Oracle University, Consulting and Vertical Education
> > Oracle Corporation
> > 500 Oracle Parkway M/S OPL-B1024
> > Redwood Shores Newsgroups:
> > California
> > 94065
> > USA
> > **** The statements and opinions expressed here are my **** **** own and do not necessarily represent those of **** **** Oracle Corporation. **** "Controlling application developers is like herding cats." Kevin Loney, ORACLE DBA Handbook "Oh no it's not! It's much harder than that!" Bruce Pihlamae, long term ORACLE DBA
> > Additional Information:
> > Last Name Sharman
> > First Name Peter
> > Version 2.1
Received on Wed Jul 14 1999 - 16:06:33 CDT