- Create CSV dumps of data and load into SQL Server via DTS packages.
- Create an ODBC connection from SQL Server to Oracle and again load it via DTS packages.
- You can use a number of ETL products like Oracle OWB, Informatica, etc. to accomplish this, however these tools are quite expensive.
Dig Deeper on Oracle data and application integration
Related Q&A from Harish Harbham
SOA and Integration expert Harish Harbham explains how to transfer data from Oracle to MS SQL Server. Continue Reading
Oracle expert Harish Harbham explains how Oracle Streams can be used for replication. Continue Reading
Expert Harish Harbham answers the question, "How do you convert SQL Server 2005 database into 0racle 10g?" Continue Reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.