RE: export tables from sql Server to Oracle

From: Adrian Roe <Adrian.Roe_at_telewest.co.uk>
Date: Wed, 01 May 2002 02:33:24 -0800
Message-ID: <F001.00454AC3.20020501023324@fatcity.com>

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). Received on Wed May 01 2002 - 05:33:24 CDT