Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> 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
![]() |
![]() |