Read tables from Oracle to SQL Server

[mel_flynn]

Hi all,

I have Oracle on an XP machine, and use the 'Oracle in OraDB10g_home1' driver to read the data. I have another Windows Server 2008 R2 machine on the same network, with SQL Server 2012 on it. What is the best way to read Oracle Tables in SQL Server? Can I setup an ODBC link from my Windows Server machine to the Oracle Database (which would require me to download an Oracle ODBC driver)? Or is the best way to export the required tables from Oracle (e.g. into csv format) and import them into SQL?

Thanking you in advance,
Imelda.

[Serge]

There are many ways of doing that.

• You can link an oracle server/db in the SQL Server then do a select from the linked server and insert into sql server table(s).
• You can import the data using sql server management studio
• Or you can just write your own code to do it.