Home » RDBMS Server » Networking and Gateways » Interface between Oracle and SQL Server databases
Interface between Oracle and SQL Server databases [message #341089] Sat, 16 August 2008 05:25 Go to next message
Messages: 6
Registered: August 2008
Junior Member

I need to trasnfer some data between an Oracle 10g database and an MS SQL server database. The first phase of my project will only require movement of data from Oracle tables to SQL Server tables. Phase two will require me to read data from the SQL server database, and use some of this data to update the Oracle database, and then write some of the Oracle info to the SQL server database.

Could you guys please point me in the right direction? What sort of info can I read up on? If there a tool which can perform these tasks? I did see something on www.dbload.com but not sure if anybody has ever used this software before?

thanks Smile
Re: Interface between Oracle and SQL Server databases [message #341110 is a reply to message #341089] Sat, 16 August 2008 10:18 Go to previous message
Messages: 25579
Registered: January 2009
Location: SoCal
Senior Member
Please read & FOLLOW the Posting Guidelines as stated in URL above

Both EXCEL & ACCESS can open connections into both MS SQLServer & Oracle. Either could be used as a bridge/interface between the 2 database servers.

Alternatively create CSV files to pass data between the 2 RDBMS.
Previous Topic: Oracle RAC (2-nodes) - Managment Connect w/TOAD
Next Topic: Help !!! - listener state:blocked
Goto Forum:

Current Time: Wed Aug 23 12:39:55 CDT 2017

Total time taken to generate the page: 0.09966 seconds