Introduction

Source hosts identify the Microsoft SQL Server instances that Data Sync reads from. This includes Azure SQL, Azure SQL Managed Instance, and on-premises Microsoft SQL Server.

To get started, open SQLSync from the landing page, then select Data Sync Source Host Configuration:

Source Host list

The list shows registered source hosts, including the instance name and whether the host is active.

Use Refresh to reload the list. Use the row Edit action to change an existing source host.

Add a source host

Select Add Source Host to open the edit dialog.

Fields:

Select Save to create or update the host, or Cancel to discard changes.

Note

Source hosts are always Microsoft SQL Server (Azure SQL, Azure SQL Managed Instance, or on-premises). Fabric instances cannot be used as sources.

Tip

Register the instance under Administration > Instances before adding it as a source host. Microsoft SQL Server instances can use Windows Authentication, SQL Server Authentication, Microsoft Entra Password, or Microsoft Entra Service Principal.