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.