Azure SQL Database

Farooq AKBAR 51 Reputation points
2022-11-08T14:44:41.597+00:00

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

Azure SQL Database
0 comments No comments
{count} vote

Accepted answer
  1. Alberto Morillo 33,251 Reputation points MVP
    2022-11-08T15:40:50.18+00:00

    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.

    0 comments No comments

2 additional answers

Sort by: Most helpful
  1. Farooq AKBAR 51 Reputation points
    2022-11-08T16:11:41.657+00:00

    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


  2. Farooq AKBAR 51 Reputation points
    2022-11-08T16:13:13.42+00:00

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

    Thanks

    0 comments No comments