RE: SqlServer data to Oracle and back to SqlServer
- From: "Aragon, Gabriel (GE Commercial Finance)" <gabriel.aragon@xxxxxx>
- To: <mcgodlewski@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 14 Sep 2005 10:23:06 -0400
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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On
Behalf Of M.Godlewski
Sent: Miércoles, 14 de Septiembre de 2005 08:15 a.m.
To: oracle-l@xxxxxxxxxxxxx
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.
Other related posts:
