Re: Move SQL Server Tables to Oracle

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
> ---------------------------------------------------------------------
> 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: KENNETH JANUSZ
  INET: kjanusz_at_att.net

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).