Re: Data Conversion Tools

Check out Data Junction... it's very flexible.. sometimes a big sluggish, but it has some really nice features such as saved conversions, multiple driver support and good field mapping.

(and no, I don't work for them)

If you want speed, you're best bet is to use the DBMS vendor's products to get the data out into a standard format (delimited, fixed length, etc), then use those DBMS vendor's utilities to bulk-load the data in.

A bit more work requiring the use of "format files", but the tradeoff in speed is tremendous.

Mike Towery <towerym_at_kochind.com> wrote in article <01bc4bff$9ff66500$f550d192_at_towerym.kochind.com>...
> For small tables ie under 1,000,000 rows I use Microsoft Access. Access
 is
> very flexible in the way you can define query to do appends.
>
> Darren Mallette <darren_at_mallette.com> wrote in article
> <3339509d.2271276_at_nntp.netcom.ca>...
> > Hi,
> >
> > I'm looking for tools that would simplify transferring data from one
> > database design to a different design (both designs on Oracle). We are
> > converting from a denormalized table structure to a normalized one and
> > want to avoid writing SQL to do the conversion as much as possible. I
> > would appreciate hearing from you if you have experience in similar
> > projects.
> >
> > Thanks,
> > -Darren
> >
> >
> > Darren Mallette
> > www.geocities.com/HotSprings/7490
> >
>
  Received on Fri Apr 18 1997 - 00:00:00 CDT