how to fetch data from oracle database in sql server 2014

• botta.5283

  SSC Veteran

  Points: 297

  More actions

  October 14, 2015 at 12:36 am

  #312210

  Hi All,

  please find the below is my requirement

  how to fetch data from oracle database in sql server 2014

  example

  ----------

  oracle schema :t1

  sql server :t2

  now am in t2 sql server database

  now am executing below query

  select * from t1.tablename ;

  please give me steps one by one

  thanks

  Venkat

• Phil Parkin

  SSC Guru

  Points: 246956

  More actions

  October 14, 2015 at 12:43 am

  #1833124

  botta.5283 (10/14/2015)

  ---

  Hi All,

  please find the below is my requirement

  how to fetch data from oracle database in sql server 2014

  example

  ----------

  oracle schema :t1

  sql server :t2

  now am in t2 sql server database

  now am executing below query

  select * from t1.tablename ;

  please give me steps one by one

  thanks

  Venkat

  Presumably you have tried searching the Internet and found no relevant articles to help you with this?

  The absence of evidence is not evidence of absence
  - Martin Rees
  The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
  - Phil Parkin