与MS Access中的链接表等效的SQL Server是什么? [英] What is the SQL Server equivalent to a linked table in MS Access?

问题描述

我来自MS Access数据库世界，我曾经使用Linked ODBC函数链接到其他数据库中的表.

I come from the MS Access database world where I'm used to link to tables in other databases using the Linked ODBC function.

与该功能等效的SQL Server是什么?

What is the SQL Server equivalent to this feature?

PS: 在SQL Server中，我想链接到其他服务器上的其他SQLServer数据库和某些Access数据库.

PS: In SQL Server I want to link to other SQLServer databases on other servers and some Access databases.

推荐答案

在SQL Server上，您可以设置LINKED SERVERS.来自 MSDN :

On SQL Server you can set up LINKED SERVERS. From MSDN:

配置链接服务器以使SQL Server数据库引擎能够 针对实例外部的OLE DB数据源执行命令 SQL Server.通常，链接服务器配置为启用 数据库引擎执行包含以下内容的Transact-SQL语句 SQL Server的另一个实例或另一个数据库产品中的表 例如Oracle.可以将许多类型的OLE DB数据源配置为 链接的服务器，包括Microsoft Access和Excel.链接服务器 具有以下优点:

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. Typically linked servers are configured to enable the Database Engine to execute a Transact-SQL statement that includes tables in another instance of SQL Server, or another database product such as Oracle. Many types OLE DB data sources can be configured as linked servers, including Microsoft Access and Excel. Linked servers offer the following advantages:

从SQL Server外部访问数据的功能.

The ability to access data from outside of SQL Server.

发出分布式查询，更新，命令和 企业中异构数据源上的事务.

The ability to issue distributed queries, updates, commands, and transactions on heterogeneous data sources across the enterprise.

类似地处理各种数据源的能力.

The ability to address diverse data sources similarly.

此处是配置链接的MSDN文章服务器

这篇关于与MS Access中的链接表等效的SQL Server是什么?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！