Hi Friends
I want to know that can I link SQL Servers to other other servers like Oracle and if it is possible then how can I do this ?
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Jignesh TrivediPosted Jul 24, 2012, 2:29 AM
yes it is possible using Linked server in SQL Server.
Configure a linked server to enable the SQL Server Database Engine to execute commands against OLE DB data sources outside of the instance of SQL Server.
it has ability to access data from outside of SQL Server.
Please refer..
http://www.c-sharpcorner.com/uploadfile/suthish_nair/linked-servers-in-sql-server-2008/
http://www.sql-programmers.com/linked-servers.aspx
hope this will help you.