Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: SOLID to ORACLE, anyone?

Re: SOLID to ORACLE, anyone?

From: Jerky <sloefex_at_>
Date: Fri, 23 Mar 2001 09:36:06 GMT
Message-ID: <aOEu6.19$7h2.13710@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 Fri Mar 23 2001 - 03:36:06 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US