Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: How to record at SqlServer using Oracle

RE: How to record at SqlServer using Oracle

From: Niall Litchfield <niall.litchfield_at_dial.pipex.com>
Date: Sat, 25 Oct 2003 10:24:24 -0800
Message-ID: <F001.005D45B1.20031025102424@fatcity.com>


You can do it in whichever db you prefer. Oracle has a product called (If I remember it correctly) transparent gateways which will give you a dblink to a sqlserver db. MS supplies the ability to link to oledb data sources - they call it linked servers, both are in the respective documentation.

Niall

> -----Original Message-----
> From: ml-errors_at_fatcity.com [mailto:ml-errors_at_fatcity.com] On
> Behalf Of Eriovaldo Andrietta
> Sent: 25 October 2003 10:54
> To: Multiple recipients of list ORACLE-L
> Subject: How to record at SqlServer using Oracle
>
>
> Hi friends
>
> How can i do for write data in SqlServer database using
> Oracle. Need I run the process in sqlserver or in Oracle ?
> What is necessary for it ? database link ?
>
> Regards
> Eriovaldo
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Eriovaldo Andrietta
> INET: eca_at_siteplanet.com.br
>
> 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: Niall Litchfield
  INET: niall.litchfield_at_dial.pipex.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 Sat Oct 25 2003 - 13:24:24 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US