Azure SQL Server –链接服务器/自主事务日志解决方法? [英] Azure SQL Server – linked server / autonomous transaction logging workaround?
问题描述
我是Azure的新手,但不是SQL Server. 在使用本地MS SQL Server时,通常在需要自治事务(自治事务–从另一个未提交的事务中提交事务)时创建链接服务器.
I am new to Azure, but not SQL Server. When using on-prem MS SQL Server I generally create linked servers when I need autonomous transactions (autonomous transactions – the commit of a transaction from within another uncommitted transaction).
不幸的是,Azure SQL Server平台似乎没有sp_addlinkedserver. 所以,我的问题是–
Unfortunately, it appears that sp_addlinkedserver is absent from the Azure SQL Server platform. So, my questions are –
- Azure SQL Server工作区中是否有一个等效的链接服务器对象?
- 仅在Azure SQL Server中(不涉及本地服务器),Azure员工在做什么以适应自主事务?
谢谢
凯文
推荐答案
KJDonovan,
Hi KJDonovan,
等效于Azure SQL数据库的链接服务器(本地SQL服务器)称为弹性查询:
The equivalent to Linked Server (On-Premise SQL server) for Azure SQL Database is called an Elastic Query:
此外,您可以查看Azure SQL数据库(单个实例)和Azure SQL数据库(托管实例)之间的比较表,就功能而言,托管实例是与本地实例最接近的部署.下列 文档有助于详细说明每个部署选项可使用的功能:
Additionally, you can take a look at this comparison table between Azure SQL Database (Single Instance) and Azure SQL Database (Managed Instance), where Managed Instance is the closest deployment to an On-Premise instance in terms of functionality. The following documentation helps to detail what functionality is available with each deployment option:
此致
这篇关于Azure SQL Server –链接服务器/自主事务日志解决方法?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!