- If you don't want to spend any extra money then you can generate a CSV file from each of the databases and use Microsoft DTS to import CSV files generated from Oracle and use SQL*Loader/External table functionality to load/read CSV files generated by SQL*Server.
- There are quite a lot of ETL tools available which allow data transformation within databases and externally. Informatica PowerCentre is an example of such a tool that will allow you to carry out ETL between SQL Server and Oracle. You can also use Oracle's OWB for this, but it requires a bit more setup than Informatica.
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