From oracle-l-bounce@freelists.org Wed Sep 14 09:55:46 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j8EEtkUL009908 for ; Wed, 14 Sep 2005 09:55:46 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id j8EEtV6H009864 for ; Wed, 14 Sep 2005 09:55:33 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 9D7831EC9A6; Wed, 14 Sep 2005 09:25:26 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 11885-04; Wed, 14 Sep 2005 09:25:26 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 172FF1EC9A0; Wed, 14 Sep 2005 09:25:26 -0500 (EST) X-MimeOLE: Produced By Microsoft Exchange V6.0.6603.0 content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C5B937.D2DDFF92" Subject: RE: SqlServer data to Oracle and back to SqlServer Date: Wed, 14 Sep 2005 10:23:06 -0400 Message-ID: <84B673E70D068347A2F54A51457E5C270C5F6361@CINMLVEM05.e2k.ad.ge.com> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: SqlServer data to Oracle and back to SqlServer Thread-Index: AcW5LmXIc8/xLN9wSlKSNhULqkcMYgACN4sw From: "Aragon, Gabriel (GE Commercial Finance)" To: , X-OriginalArrivalTime: 14 Sep 2005 14:23:07.0016 (UTC) FILETIME=[D35A0880:01C5B937] X-archive-position: 25420 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: gabriel.aragon@ge.com Precedence: normal Reply-To: gabriel.aragon@ge.com X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-mailscan-MailScanner-Information: Please contact the ISP for more information X-mailscan-MailScanner: Found to be clean X-MailScanner-From: oracle-l-bounce@freelists.org X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on air891.startdedicated.com X-Spam-Status: No, hits=-3.6 required=5.0 tests=AWL,BAYES_00,CASHCASHCASH, CLICK_BELOW,HTML_FONTCOLOR_BLUE,HTML_LINK_CLICK_HERE,HTML_MESSAGE autolearn=no version=2.63 ------_=_NextPart_001_01C5B937.D2DDFF92 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable You can move data from MS to ORA using DTS and odbc, or using a linked = server (hard to configure AFAIK), and also you can configure in oracle = HETEROGENEOUS SERVICES (HS) using transparent gateway (TG) $$$ or free = (and limited) Oracle Connectivity (OC).. google for more info.. also = oracle technet..=20 -----Original Message----- From: oracle-l-bounce@freelists.org = [mailto:oracle-l-bounce@freelists.org]On Behalf Of M.Godlewski Sent: Mi=E9rcoles, 14 de Septiembre de 2005 08:15 a.m. To: oracle-l@freelists.org Subject: SqlServer data to Oracle and back to SqlServer What is the best way to move data between MS SqlServer and Oracle? I'm working on a project that is going to get data from MS SqlServer. = What is the best way to ask for this data? Is XML or comma delimeted = files better? We then plan to send updated data back to MS SqlServer. Anyone doing this? What do you recommend? What are the pitfalls to = watch out for? =20 TIA _____ =20 Yahoo! for Good Click here to donate to the = Hurricane Katrina relief effort.=20 ------_=_NextPart_001_01C5B937.D2DDFF92 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

You=20 can move data from MS to ORA using DTS and odbc, or using a linked = server (hard=20 to configure AFAIK), and also you can configure in oracle HETEROGENEOUS = SERVICES=20 (HS) using transparent gateway (TG) $$$ or free (and limited) Oracle=20 Connectivity (OC).. google for more info.. also oracle technet..=20

-----Original Message-----
From:=20 oracle-l-bounce@freelists.org = [mailto:oracle-l-bounce@freelists.org]On=20 Behalf Of M.Godlewski
Sent: Mi=E9rcoles, 14 de = Septiembre de 2005=20 08:15 a.m.
To: oracle-l@freelists.org
Subject: = SqlServer=20 data to Oracle and back to SqlServer

What is the best way to move data between MS SqlServer and = Oracle?

I'm working on a project that is going to get data from MS=20 SqlServer. What is the best way to ask for this data? Is = XML or=20 comma delimeted files better?

We then plan to send updated data back to MS SqlServer.

Anyone doing this? What do you recommend? What are = the=20 pitfalls to watch out for?

TIA

Yahoo! for Good
Click=20 here to donate to the Hurricane Katrina relief effort.=20

------_=_NextPart_001_01C5B937.D2DDFF92-- -- http://www.freelists.org/webpage/oracle-l