RE: SqlServer data to Oracle and back to SqlServer

One word, tg4msql from Oracle.

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of M.Godlewski Sent: Wednesday, September 14, 2005 9:15 AM 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 here to donate <http://store.yahoo.com/redcross-donate3/> to the Hurricane Katrina relief effort.

--
http://www.freelists.org/webpage/oracle-l