Home » SQL & PL/SQL » SQL & PL/SQL » Oracle to SQL Server (Oracle 11g R2)
Oracle to SQL Server [message #576418] Mon, 04 February 2013 15:28 Go to next message
kvignes1
Messages: 33
Registered: September 2007
Member

We have a requirement to pull data from SQL Server to oracle.

Source Server: SQL Server
Target Server - Oracle 11g R2.

We have few tables in SQL Server which we need to load to Oracle database.

Pls let me know the best solution.

I came across the below link . Is that a only solution? Pls let me know
http://www.ritzyblogs.com/OraTalk/PostID/107/Heterogenous-connection-from-Oracle-database-to-Microsoft-SQL-server
Re: Oracle to SQL Server [message #576423 is a reply to message #576418] Mon, 04 February 2013 16:06 Go to previous messageGo to next message
Barbara Boehmer
Messages: 8024
Registered: November 2002
Location: California, USA
Senior Member
There are always various ways to do things. If this is a one-time thing and you just have a few small tables, then I might be more inclined to export the tables to text files, either fixed format or delimited, then use either SQL*Loader or external tables to load them into your Oracle database.
Re: Oracle to SQL Server [message #576424 is a reply to message #576423] Mon, 04 February 2013 16:14 Go to previous messageGo to next message
kvignes1
Messages: 33
Registered: September 2007
Member

Nope. This is going to be on regular monthly basis.
Re: Oracle to SQL Server [message #576425 is a reply to message #576424] Mon, 04 February 2013 17:20 Go to previous message
BlackSwan
Messages: 23186
Registered: January 2009
Senior Member
http://www.oracle.com/pls/db112/search?word=transparent+gateway&partno=
Previous Topic: Read different number of records.
Next Topic: ORACLE - SYS.DBMS_JOB causes error "ORA-01461 can bind a LONG value only for insert into a LONG colu
Goto Forum:
  


Current Time: Fri Dec 26 13:20:15 CST 2014

Total time taken to generate the page: 0.21871 seconds