FAQ
There are two ways ..

Use Procedural Gateways to get at SQL Server Tables thru Oracle and do a
CTAS.

Bring the data onto a Flat file using the export utility in SQL Serer and
upload to Oracle using SQL Loader.

HTH

Best Regards,
Ganesh R

Tel : +971 (4) 397 3337 Ext 420
Fax : +971 (4) 397 6262
HP : +971 (50) 745 6019
============================================

Live to learn... forget... and learn again.

-----Original Message-----
Sent: Wednesday, May 01, 2002 1:17 AM
To: Multiple recipients of list ORACLE-L

Hi listers,

Can someone tell me how import tables from SQLServer
to Oracle.

Thanks for your help,

Ben

Do You Yahoo!?
Yahoo! Health - your guide to health and wellness http://health.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Kader Ben
INET: kaderb_at_yahoo.com

Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

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.com
--
Author: Ganesh Raja
INET: ganesh_at_gtfs-gulf.com

Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

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

Search Discussions

  • Farnsworth, Dave at May 1, 2002 at 9:34 am
    The easiest is to use the SQL Server DTS utility. I use it all the time to move data between SQL Server, Oracle, DB2 and other heterogenous sources/destinations.

    Dave

    -----Original Message-----
    Sent: Tuesday, April 30, 2002 4:17 PM
    To: Multiple recipients of list ORACLE-L

    Hi listers,

    Can someone tell me how import tables from SQLServer
    to Oracle.

    Thanks for your help,

    Ben

    Do You Yahoo!?
    Yahoo! Health - your guide to health and wellness
    http://health.yahoo.com
    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: Kader Ben
    INET: kaderb_at_yahoo.com

    Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
    San Diego, California -- Public Internet access / Mailing Lists
    --------------------------------------------------------------------

    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.com
    --
    Author: Farnsworth, Dave
    INET: DFarnsworth_at_Ashleyfurniture.com

    Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
    San Diego, California -- Public Internet access / Mailing Lists
    --------------------------------------------------------------------

    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).
  • Adrian Roe at May 1, 2002 at 10:33 am
    Why don't you create a linked server in SQL Server that points at the Oracle
    OLEDB/ODBC driver. So long as you have Oracle client installed on the SQL
    Server box you should be able to reference the Oracle tables directly.

    -----Original Message-----
    Sent: 30 April 2002 22:17
    To: Multiple recipients of list ORACLE-L

    Hi listers,

    Can someone tell me how import tables from SQLServer
    to Oracle.

    Thanks for your help,

    Ben

    Do You Yahoo!?
    Yahoo! Health - your guide to health and wellness
    http://health.yahoo.com
    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: Kader Ben
    INET: kaderb_at_yahoo.com

    Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
    San Diego, California -- Public Internet access / Mailing Lists
    --------------------------------------------------------------------

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

    Live Life in Broadband
    www.telewest.co.uk

    The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material.
    Statements and opinions expressed in this e-mail may not represent those of the company. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender immediately and delete the material from any computer.

    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: Adrian Roe
    INET: Adrian.Roe_at_telewest.co.uk

    Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
    San Diego, California -- Public Internet access / Mailing Lists
    --------------------------------------------------------------------

    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).
  • Jim Hawkins at May 1, 2002 at 2:23 pm
    If you are on SQL*Server 2000, you can use DTS (Data Transformation Services) to unload data to Oracle.

    Jim

    Kader Ben wrote:
    Hi listers,

    Can someone tell me how import tables from SQLServer
    to Oracle.

    Thanks for your help,

    Ben

    __________________________________________________
    Do You Yahoo!?
    Yahoo! Health - your guide to health and wellness
    http://health.yahoo.com
    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: Kader Ben
    INET: kaderb_at_yahoo.com

    Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
    San Diego, California        -- Public Internet access / Mailing Lists
    --------------------------------------------------------------------
    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).
    --
    _____________________________
    Jim Hawkins
    Oracle Database Administrator
    VelvetMellocet_at_netscape.net
    St. Louis, MO  USA

    __________________________________________________________________
    Your favorite stores, helpful shopping tools and great gift ideas. Experience the convenience of buying online with Shop@Netscape! http://shopnow.netscape.com/

    Get your own FREE, personal Netscape Mail account today at http://webmail.netscape.com/

    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: Jim Hawkins
    INET: VelvetMellocet_at_netscape.net

    Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
    San Diego, California -- Public Internet access / Mailing Lists
    --------------------------------------------------------------------
    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).
  • Farnsworth, Dave at May 1, 2002 at 2:43 pm
    You can use DTS in SQL Server 7.0 also to move data to Oracle.

    -----Original Message-----
    Sent: Wednesday, May 01, 2002 9:23 AM
    To: Multiple recipients of list ORACLE-L

    If you are on SQL*Server 2000, you can use DTS (Data Transformation Services) to unload data to Oracle.

    Jim

    Kader Ben wrote:
    Hi listers,

    Can someone tell me how import tables from SQLServer
    to Oracle.

    Thanks for your help,

    Ben

    __________________________________________________
    Do You Yahoo!?
    Yahoo! Health - your guide to health and wellness
    http://health.yahoo.com
    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: Kader Ben
    INET: kaderb_at_yahoo.com

    Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
    San Diego, California        -- Public Internet access / Mailing Lists
    --------------------------------------------------------------------
    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).
    --
    _____________________________
    Jim Hawkins
    Oracle Database Administrator
    VelvetMellocet_at_netscape.net
    St. Louis, MO  USA

    __________________________________________________________________
    Your favorite stores, helpful shopping tools and great gift ideas. Experience the convenience of buying online with Shop@Netscape! http://shopnow.netscape.com/

    Get your own FREE, personal Netscape Mail account today at http://webmail.netscape.com/

    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: Jim Hawkins
    INET: VelvetMellocet_at_netscape.net

    Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
    San Diego, California -- Public Internet access / Mailing Lists
    --------------------------------------------------------------------
    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.com
    --
    Author: Farnsworth, Dave
    INET: DFarnsworth_at_Ashleyfurniture.com

    Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
    San Diego, California -- Public Internet access / Mailing Lists
    --------------------------------------------------------------------
    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).

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouporacle-l @
categoriesoracle
postedMay 1, '02 at 9:28a
activeMay 1, '02 at 2:43p
posts5
users4
websiteoracle.com

People

Translate

site design / logo © 2022 Grokbase