Using Microsoft Sql Server, we can create links to the Object Linking and Embedding(OLE) Database Datasources, this process is called as Linked Servers.
After creating the link we can query into the remote databases using RowSets which will have the reference to tables in the OLE DB DataSources. Every distributed Query will refer multiple linked servers and hence can perform update or read operations to each individual linked servers. A single distributed query can perform read and update operations to different set of linked servers.
|
