Link a Sql Server

Question

Normal 0 false false false EN-US X-NONE X-NONE /* Style Definitions */ table.MsoNormalTable{mso-style-name:Table Normal;mso-tstyle-rowband-size:0;mso-tstyle-colband-size:0;mso-style-noshow:yes;mso-style-priority:99;mso-style-qformat:yes;mso-style-parent:;mso-padding-alt:0in 5.4pt 0in 5.4pt;mso-para-margin-top:0in;mso-para-margin-right:0in;mso-para-margin-bottom:10.0pt;mso-para-margin-left:0in;line-height:115%;mso-pagination:widow-orphan;font-size:11.0pt;font-family:Calibrisans-serif;mso-ascii-font-family:Calibri;mso-ascii-theme-font:minor-latin;mso-hansi-font-family:Calibri;mso-hansi-theme-font:minor-latin;} Hi friends......... I want to link a Sql Server to another? Can I link only other SQL Servers or any database servers such as Oracle?If yes then how? Thanks.........

Satyapriya Nayak · Answer

Hi Vikas Linked Servers is a concept in SQL Server by which we can add other SQL Server to a Group and query both the SQL Server dbs using T-SQL Statements. We can link any server provided we have the OLE-DB provider from Microsoft to allow a link. For Oracle we have a OLE-DB provider for oracle that microsoft provides to add it as a linked server to the sql server group. Please refer the below links http://www.c-sharpcorner.com/uploadfile/suthish_nair/linked-servers-in-sql-server-2008/ http://www.dba-oracle.com/t_heterogeneous_database_connections_sql_server.htm Thanks

Vikas Mishra · Answer

Thanks.......