Re: SOLID to ORACLE, anyone?

You could use my SQL*XL utility and go via Excel. For data management & import Excel is quite good. I don't know your SOLID database but I would assume you could export to one of the formats supported by Excel (csv, flat file, mdb, etc). SQL*XL can then upload the data straightforwardly into Oracle.

Have a look at SQL*XL at http://www.oraxcel.com

Kind regards, Gerrit-Jan Linker

"Jerky .hotmail.com>" <sloefex@<nospam> wrote in message news:aOEu6.19$7h2.13710_at_nreader2.kpnqwest.net...
> Emmanuel
>
> Over here, I had the same problem: I started with SQL*loader, too. Solid
> SolExp exports the fields with quotes and NULLs ... and this gave me lots
 of
> trouble and bad data.
>
> Afterwards, I wrote a VisualBasic program for this that only transfers new
> and updated records instead of everything and that also makes sure that
 the
> data comes in clean (trims, checks and stuff). To do this, I use an insert
> and an update trigger on the tables that need to be imported that puts the
> 'to be imported' keys in a separate table that is read and modified
 (cleaned
> up) by my program. I use a timer that is fired regularly, so it is kind of
 a
> constant feed ... I use OLEDB to do this ...
>
> Something to think about: my program reads the TABLES and COLUMNS of both
> Solid and Oracle, so the user can connect the Solid fields to the Oracle
> fields in a GUI and these connections are stored in the DB too. That way,
> the INSERT and UPDATE statements are dynamically built without me having
 to
> change the code every time a field changes ...
>
> During the transfer, I reach an average of 72 records per second, which is
> not bad because my Oracle server machine is a cranky old thing with almost
> no memory ;-) and the network is also a bottleneck ...
>
> Good luck
>
> Kristof Vermeire
> sloefex@<nospam>.hotmail.com
>
> "Emmanuel T." <loke_fr_at_hotmail.com> wrote in message
> news:97312q$c33$1_at_reader1.imaginet.fr...
> > I have a SOLID database, running on NT and I want to feed the data into
 an
> > Oracle database (8i) on solaris. So far, I have been able to do it by
> > exporting the data from SOLID to plain text, and then fire up sql*loader
 to
> > fill up the ORACLE db.
> > Any other way to do it, more like a constant feed?
> >
> > TIA
> > Emmanuel
> >
> >
>
>
Received on Sat Mar 31 2001 - 08:36:08 CST