Connect steps

• piduruviswa

  SSC Journeyman

  Points: 85

  More actions

  August 8, 2008 at 10:57 am

  #211047

  Hello All,

  I am new to SQL server. We have a requirement to read Oracle and Postgres data from SQL server. I am not sure about the steps to follow in creating the DBLink in SQL Server to read the data from external RDBMS. Pls help.

  If it is a frequently asked query please point me to the right link.

  Thanks

  Rock

• upalsen

  Old Hand

  Points: 381

  More actions

  August 13, 2008 at 3:47 am

  #857254

  EXEC master.dbo.sp_addlinkedserver @server = N'ORA_LINK',

  @srvproduct=N'Oracle', @provider=N'MSDAORA', @datasrc=N' '

  then u can select from the above oracle database as below

  select * from ORA_LINK..SCHEMA_NAME.TABLE_NAME