| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Move SQL Server Tables to Oracle
Yeah, that's what I thought, though I'm not familiar with UPI.
Sorry, question was kind of "tongue in cheek" -:)
Igor Neyman, OCP DBA
ineyman_at_perceptron.com
-----Original Message-----
Tanel Poder
Sent: Thursday, September 18, 2003 6:20 PM
To: Multiple recipients of list ORACLE-L
No it doesn't, sqlldr probably uses OCI... or in some cases maybe even lower-level layer, UPI (user program interface).
Tanel.
> Ken,
>
> Could you please elaborate on how SQL*Loader uses SQL*Plus?
>
> Igor Neyman, OCP DBA
> ineyman_at_perceptron.com
>
>
>
> -----Original Message-----
> KENNETH JANUSZ
> Sent: Thursday, September 18, 2003 3:40 PM
> To: Multiple recipients of list ORACLE-L
>
> That will work as long as they are sets of tables are the same layout.
> If
> not, then you have to map from SQL Server to Oracle which could be a
> complex
> time consuming task. Then the best bet is to generate delimited flat
> files
> from SQL Server and use SQL*Loader to load them into Oracle. For this
I
> recommend the book: SQL*Loader, The definitive Guide by Gennick &
> Mishra.
>
> Sorry to say it SQL*Loader uses SQL*Plus, not Perl.
>
> My $0.02 worth,
>
> Ken Janusz, CPIM
>
>
> ----- Original Message -----
> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> Sent: Thursday, September 18, 2003 2:59 PM
>
>
> >
> > If you are familiar with Perl and DBI, you can pre-create
> > the tables in Oracle, open a connection to both the MS
> > and Oracle databases, select from MS, insert to Oracle.
> >
> > Do it all in one step, it's pretty straightforward.
> >
> > Jared
> >
> > On Thu, 2003-09-18 at 00:59, Gunnar Berglund wrote:
> > > Hi all,
> > >
> > > I need to move some sql server tables to oracle.
> > >
> > > Do you have some ideas how to do it. I have no idea ...
> > >
> > > rgds
> > > G
> > >
> > >
> > > ---------------------------------
> > > Want to chat instantly with your online friends? Get the FREE
> Yahoo!Messenger
> >
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > --
> > Author: Jared Still
> > INET: jkstill_at_cybcon.com
> >
> > Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> > San Diego, California -- Mailing list and web hosting
services
> >
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: tanel.poder.003_at_mail.ee Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Igor Neyman INET: ineyman_at_perceptron.com Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).Received on Fri Sep 19 2003 - 09:29:44 CDT
 |
 |