The September 2023 release adds support for linking two managed SQL Server instances.

Server Instance

The Create link to server instance resource (CREATE /sql-instances/{instance-name}/linked-servers/{linked-server-name}) enables you to create a link between two managed server instances in a Data Bridge cluster. This resource takes two required path parameters (instance-name, linked-server-name) and one required body parameter (description) that provides information about the link.

Once the link between the two managed SQL Server instances is created, principals assigned the Consumer or Contributor roles can query data across servers provided that they have access to the databases on both of the linked SQL Server instances.

Principals with the Data Bridge Admin role can add or delete links managed SQL Server instances. To learn more about role-based permissions in Data Bridge, see Groups and Roles.

The Get Linked Server Instances resource (GET /sql-instances/{instance-name}) returns a list of links between managed server instances in the Data Bridge cluster.

Principals with either the Consumer or Contributor role can use this resource to view a list of the managed SQL Server instances linked to the managed server instance specified in the instance-name path parameter.

The Delete Link to Server Instance resource (DELETE /sql-instances/{instance-name}/linked-servers/{linked-server-name}) enables you to delete the link between two managed SQL Server instances.

Once the link between the two managed SQL Server instances is deleted, no one can query data across server instances.

Principals with the Data Bridge Admin role can delete links between managed SQL Server instances.