SQL azure的Sqltabledependency（或类似的东西） [英] Sqltabledependency (or something similar) with SQL azure

问题描述

我正在考虑将系统迁移到Azure SQL数据库 - 但我要求代理服务正在运行，以便服务可以使用SqlTableDependency检测更改。



我不想每分钟轮询数据库 - 我更喜欢'正确'的解决方案。



有没有人提出任何建议 - 因为我用谷歌搜索了它我还没有看到任何东西....



或者是否有一种完全不同的方式来使用SQL中的API（如果存在这样的话）



谢谢



我的尝试：



我试过研究这个 - 但是寻找可能已经做过的人的建议，看看它是否正常。

I'm looking at moving a system to an Azure SQL database - but i require the broker service to be running so a service can detect changes using SqlTableDependency.

I don't want to poll the database every minute - i would prefer a 'proper' solution.

Has anyone any suggestions - as I've googled it and i've not seen anything yet....

Or is there a completely different way to do using an API from SQL ( if such a thing exists )

Thanks

What I have tried:

I have tried researching this - but looking for suggestions from people who may have already done it to see if it works OK.

推荐答案

最大问题：您无法在AZURE SQL数据库上启用Service Broker



请参阅： Resolvi ng T-SQL差异 - 迁移 - Azure SQL数据库| Microsoft Docs [ ^ ]



部分：

具有部分差异的Transact-SQL语法语句

核心DDL（数据定义语言）语句可用，但某些DDL语句具有与磁盘放置和不支持的功能相关的扩展。



CREATE和ALTER DATABASE语句具有超过三十个选项。这些语句包括仅适用于SQL Server的文件放置，FILESTREAM和服务代理选项。如果在迁移之前创建数据库，这可能无关紧要，但如果要迁移创建数据库的T-SQL代码，则应将CREATE DATABASE（Azure SQL数据库）与CREATE DATABASE（SQL Server Transact-SQL）中的SQL Server语法进行比较。确保支持您使用的所有选项。 Azure SQL数据库的CREATE DATABASE也有服务目标和弹性比例选项，仅适用于SQL数据库。



你不能'sp_configure options和RECONFIGURE'数据库，所以你不能启用.NET CLR



这是一个很糟糕的

Biggiest issue: You cannot enable the Service Broker on an AZURE SQL Database

see: Resolving T-SQL differences-migration-Azure SQL Database | Microsoft Docs[^]

part:
Transact-SQL syntax statements with partial differences
The core DDL (data definition language) statements are available, but some DDL statements have extensions related to disk placement and unsupported features.

CREATE and ALTER DATABASE statements have over three dozen options. The statements include file placement, FILESTREAM, and service broker options that only apply to SQL Server. This may not matter if you create databases before you migrate, but if you are migrating T-SQL code that creates databases you should compare CREATE DATABASE (Azure SQL Database) with the SQL Server syntax at CREATE DATABASE (SQL Server Transact-SQL) to make sure all the options you use are supported. CREATE DATABASE for Azure SQL Database also has service objective and elastic scale options that apply only to SQL Database.

You cannot 'sp_configure options and RECONFIGURE' the database so you cannot enable the .NET CLR

it is a pitty

这篇关于SQL azure的Sqltabledependency（或类似的东西）的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！