Re: Move SQL Server Tables to Oracle

The rather terse initial post says "move some sql server tables to oracle".

No mention of changing design.

On Thu, 2003-09-18 at 13:39, KENNETH JANUSZ wrote:
> 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).
>

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