Create Linked Server at MS SQL to Oracle

Question

I was wondering how to create synonym at MS SQL Server that will link my Oracle database? My tables all are at Oracle database. Thanks in advance.

Pred · Accepted Answer · 2014-05-05 06:26:33Z

-1

I think, you are looking for the feature called 'Linked Server'. If so, start reading here: http://technet.microsoft.com/en-us/library/ms188279.aspx

answered May 5, 2014 at 6:26

Pred

9,0903 gold badges28 silver badges47 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

sam yi · Accepted Answer · 2014-05-05 06:35:30Z

-1

You'll need to create a linked server then use synonym on top of that if you need the level of abstraction.

answered May 5, 2014 at 6:35

sam yi

4,9451 gold badge33 silver badges41 bronze badges

I need to link to Oracle database. Is that possible?