From oracle-l-bounce@freelists.org Wed Sep 14 08:35:47 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j8EDZjOY028176 for ; Wed, 14 Sep 2005 08:35:45 -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 j8EDZf6H028157 for ; Wed, 14 Sep 2005 08:35:41 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id DE1631EC83C; Wed, 14 Sep 2005 08:35:35 -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 02813-09; Wed, 14 Sep 2005 08:35:35 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 6355D1EC805; Wed, 14 Sep 2005 08:35:35 -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_01C5B92F.8618F449" Subject: RE: SqlServer data to Oracle and back to SqlServer Date: Wed, 14 Sep 2005 09:23:41 -0400 Message-ID: <4001DEAF7DF9BD498B58B45051FBEA6502C8BBB5@25exch1.vicorpower.vicr.com> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: SqlServer data to Oracle and back to SqlServer thread-index: AcW5LpWeGdqvgFXIT8el5hSGmK5FSgAAOXlw From: "Goulet, Dick" To: , X-OriginalArrivalTime: 14 Sep 2005 13:23:41.0654 (UTC) FILETIME=[863AF760:01C5B92F] X-archive-position: 25414 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: DGoulet@vicr.com Precedence: normal Reply-To: DGoulet@vicr.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.3 required=5.0 tests=AWL,BAYES_00,CLICK_BELOW, HTML_FONTCOLOR_BLUE,HTML_LINK_CLICK_HERE,HTML_MESSAGE autolearn=no version=2.63 ------_=_NextPart_001_01C5B92F.8618F449 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable One word, tg4msql from Oracle. _____ =20 From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org] On Behalf Of M.Godlewski Sent: Wednesday, September 14, 2005 9:15 AM 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_01C5B92F.8618F449 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

One word, tg4msql from = Oracle.

From: oracle-l-bounce@freelists.org=20 [mailto:oracle-l-bounce@freelists.org] On Behalf Of=20 M.Godlewski
Sent: Wednesday, September 14, 2005 9:15=20 AM
To: oracle-l@freelists.org
Subject: SqlServer = data to=20 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. =20 What is the best way to ask for this data? Is XML or comma = delimeted=20 files better?

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

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

TIA

Yahoo! for Good
Click here=20 to donate to the Hurricane Katrina relief effort. ------_=_NextPart_001_01C5B92F.8618F449-- -- http://www.freelists.org/webpage/oracle-l