Azure SQL Database

Question

Hi All,

Can someone please confirm if we can add additional data models to Azure AQL database for use cases like Message Broker Solutions?

Answers will be much appreciated.

Thanks

Answer 1

Azure SQL Database (DTU and vCore models) do not support message exchange using service broker. Maybe you should consider using Azure SQL Managed Instance instead.

Azure SQL Managed Instance supports service broker solutions, but you are using remote Service Broker routes, you need to try to consolidate databases from several distributed SQL Server instances into one SQL Managed Instance and use only local routes.

Answer 2

Hi Alberto Thanks for your response. My aim is to have a Database which can incorporate any changes made to logic model of database/schema which are prepared by BA Team and stored in the binary proprietary format.Since XSD-schema enables applying the difference tools and allows version controlling. We have a tool which is used to store the difference in SQL format as a set of logical DB transformations. Consequence application of such transformations enables migration of the existing database to the new version. This allows to bind the physical change in the database to logical reason to change in the system (i.e. new feature implementation). A set of migrations for a version results into a version update SQL-script

Answer 3

@Alberto Morillo Can you please confirm if I can achieve the above requirements with any type of SQL Databases offered by Azure?

Thanks