RE: SqlServer data to Oracle and back to SqlServer

From: Aragon, Gabriel (GE Commercial Finance) <gabriel.aragon_at_ge.com>
Date: Wed, 14 Sep 2005 10:23:06 -0400
Message-ID: <84B673E70D068347A2F54A51457E5C270C5F6361@CINMLVEM05.e2k.ad.ge.com>

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

-----Original Message-----

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]On Behalf Of M.Godlewski Sent: Miércoles, 14 de Septiembre de 2005 08:15 a.m. To: oracle-l_at_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?

TIA

Yahoo! for Good
Click <http://store.yahoo.com/redcross-donate3/> here to donate to the Hurricane Katrina relief effort.

--

http://www.freelists.org/webpage/oracle-l Received on Wed Sep 14 2005 - 09:55:46 CDT