Home > IT Answers > Oracle > Retrieve data from Oracle9i to SQL server
Xue87
15 pts.
 Retrieve data from Oracle9i to SQL server
Oracle, Oracle 9i, Oracle SQL, SQL
Currently my database client using SQL Server 2005 and there have another database whereby is using Oracle 9i, I wanted to retrieve the data from the oracle whereby query in SQL server 2005. 

Software/Hardware used:
ASKED: January 19, 2010  10:42 AM
UPDATED: January 20, 2010  2:46 AM
RELATED QUESTIONS
Answer Wiki:
You'll want to look into using SQL Server Integration Services (SSIS) to copy the needed records from the Oracle database to the SQL Server database.
Last Wiki Answer Submitted:  January 19, 2010  11:56 pm  by  Denny Cherry   64,520 pts.
All Answer Wiki Contributors:  Denny Cherry   64,520 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

If there got any way to retrieve the from the other database without copying any record from oracle database?

Xue87
 15 pts.