load a table from Solomon on NT to Oracle on Unix
From: Shuchun Zhang <shuchunz_at_gradient.cis.upenn.edu>
Date: Mon, 17 Aug 1998 17:07:26 -0400
Message-ID: <35D89B8E.4C306B73_at_gradient.cis.upenn.edu>
Need help on this:
Date: Mon, 17 Aug 1998 17:07:26 -0400
Message-ID: <35D89B8E.4C306B73_at_gradient.cis.upenn.edu>
Need help on this:
We have two servers, one runs Solomon DB on NT, the other runs Oracle on
Unix.
Now we nedd to load a table in Solomon to Oracle on a daily basis.
we have a method which is not so satisfying:
Every morning get data from Solomon and write it as flat file, then from Unix we
can ftp(or whatever) the flat file and then insert into DB.
we'd like a method that won't add anything on NT, just a script on Unix
box, how can we
access Solomon on NT within from Unix on another server?
thanks.
Shu Received on Mon Aug 17 1998 - 23:07:26 CEST