create link in sql server 2014

• botta.5283

  SSC Veteran

  Points: 297

  More actions

  October 13, 2015 at 3:36 am

  #304173

  Hi all,

  how to create link in sql server 2014 from oraclle database

  i want show the data in sql server from oracle database

  for example select * from oracle schema.tablename (in sql server 2014 need to run)

  thanks More help

• botta.5283

  SSC Veteran

  Points: 297

  More actions

  October 13, 2015 at 4:01 am

  #1832940

  hi all

  How can i fetch the data from oracle database in sql server

• John Mitchell-245523

  SSC Guru

  Points: 148809

  More actions

  October 13, 2015 at 4:08 am

  #1832946

  SSIS, OPENROWSET, linked server... it depends on your requirements.

  John