Download ECHO OLE DB Data Provider User Guide

Transcript
7-2
Chapter 7
Microsoft SQL Server Linked Server
Linked Server is a term for a virtual RDBMS server that is linked into Microsoft
SQL Server. The linked server configuration allows the Microsoft SQL Server to
execute commands against OLE DB data sources on different servers.
Linked servers offer these advantages.
ƒ
Remote server access.
ƒ
Ability to issue distributed queries, updates, commands, and transactions on
heterogeneous data sources across the enterprise.
ƒ
Ability to address diverse data sources similarly.
The Linked Servers functionality is available in Microsoft SQL Server 7.0 and
greater.
NOTE: ECHO OLE DB requires Microsoft SQL Server 2000 to operate
as a Linked Server.
The following figure illustrates the linked server architecture of the Microsoft SQL
Server.
Distributed queries are queries, that access data stored in SQL Server
(homogeneous data) plus data stored in a data store other than SQL Server
(heterogeneous data from SQL Server point of view). Distributed queries operate
as if all data is stored in SQL Server. Each distributed query can reference multiple
linked servers and can perform either update or read operations against each
individual linked server.