![](https://it-infrastructure.solutions/content/images/2022/09/image-335.png)
This article has not been completed yet. However, it may already contain helpful Information and therefore it has been published at this stage.
Prerequisites:
- Open outbound Connection - TCP / Port 1433
- Onpremise SQL Database - Server
- Database (AdventureWorksDW2019.bak)
- Tables that should be synchronized need to be equipped with a primary key - "DBO.DimCustomer"
Demo-Environment:
![](https://it-infrastructure.solutions/content/images/2022/09/Demo-Environment-3.png)
Creating a Resource Group
![](https://it-infrastructure.solutions/content/images/2022/09/image-339.png)
![](https://it-infrastructure.solutions/content/images/2022/09/image-340.png)
![](https://it-infrastructure.solutions/content/images/2022/09/image-336.png)
![](https://it-infrastructure.solutions/content/images/2022/09/image-337.png)
![](https://it-infrastructure.solutions/content/images/2022/09/image-338.png)
Creating an Azure - Database:
![](https://it-infrastructure.solutions/content/images/2022/09/image-341.png)
![](https://it-infrastructure.solutions/content/images/2022/09/image-342.png)
![](https://it-infrastructure.solutions/content/images/2022/09/image-307.png)
![](https://it-infrastructure.solutions/content/images/2022/09/image-308.png)
![](https://it-infrastructure.solutions/content/images/2022/09/image-343.png)
![](https://it-infrastructure.solutions/content/images/2022/09/image-344.png)
![](https://it-infrastructure.solutions/content/images/2022/09/image-345.png)
![](https://it-infrastructure.solutions/content/images/2022/09/image-346.png)
![](https://it-infrastructure.solutions/content/images/2022/09/image-347.png)
Sync - Setup
![](https://it-infrastructure.solutions/content/images/2022/09/image-348.png)
![](https://it-infrastructure.solutions/content/images/2022/09/image-349.png)
![](https://it-infrastructure.solutions/content/images/2022/09/image-350.png)
![](https://it-infrastructure.solutions/content/images/2022/09/image-351.png)
![](https://it-infrastructure.solutions/content/images/2022/09/image-317.png)
![](https://it-infrastructure.solutions/content/images/2022/09/image-318.png)
![](https://it-infrastructure.solutions/content/images/2022/09/image-353.png)
![](https://it-infrastructure.solutions/content/images/2022/09/image-354.png)
Caution: It is important to archive the agent key, as it will be needed at a later point in time.
Installing the Sync Agent (onprem)
Downloadlink: https://www.microsoft.com/en-us/download/details.aspx?id=27693
![](https://it-infrastructure.solutions/content/images/2022/09/image-321.png)
![](https://it-infrastructure.solutions/content/images/2022/09/image-322.png)
![](https://it-infrastructure.solutions/content/images/2022/09/image-323.png)
![](https://it-infrastructure.solutions/content/images/2022/09/image-324.png)
![](https://it-infrastructure.solutions/content/images/2022/09/image-325.png)
![](https://it-infrastructure.solutions/content/images/2022/10/grafik-28.png)
There are several options:
- LocalSystem
- MSA - Managed Service Account
- Service Account (Domain User)
![](https://it-infrastructure.solutions/content/images/2022/09/image-327.png)
![](https://it-infrastructure.solutions/content/images/2022/09/image-328.png)
Configuration of the Sync Agent Part 1
![](https://it-infrastructure.solutions/content/images/2022/10/grafik-2.png)
![](https://it-infrastructure.solutions/content/images/2022/09/image-331.png)
At this point, we'll make a short break and perform one more customization in Azure.
SQL Firewall Adjustment in Azure:
![](https://it-infrastructure.solutions/content/images/2022/10/image-1.png)
![](https://it-infrastructure.solutions/content/images/2022/10/image-2.png)
![](https://it-infrastructure.solutions/content/images/2022/10/image-3.png)
![](https://it-infrastructure.solutions/content/images/2022/10/image-4.png)
![](https://it-infrastructure.solutions/content/images/2022/10/grafik-25.png)
![](https://it-infrastructure.solutions/content/images/2022/09/image-333.png)
Configuration of the Sync Agent Part 2
![](https://it-infrastructure.solutions/content/images/2022/10/image.png)
![](https://it-infrastructure.solutions/content/images/2022/09/image-334.png)
![](https://it-infrastructure.solutions/content/images/2022/10/image-5.png)
![](https://it-infrastructure.solutions/content/images/2022/10/grafik-3.png)
![](https://it-infrastructure.solutions/content/images/2022/10/grafik-4.png)
![](https://it-infrastructure.solutions/content/images/2022/10/grafik-5.png)
![](https://it-infrastructure.solutions/content/images/2022/10/grafik-6.png)
![](https://it-infrastructure.solutions/content/images/2022/10/grafik-8.png)
Adding the OnPrem Database to the Syncgroup
![](https://it-infrastructure.solutions/content/images/2022/10/grafik-10.png)
![](https://it-infrastructure.solutions/content/images/2022/10/grafik-9.png)
![](https://it-infrastructure.solutions/content/images/2022/10/grafik-11.png)
![](https://it-infrastructure.solutions/content/images/2022/10/grafik-12.png)
![](https://it-infrastructure.solutions/content/images/2022/10/grafik-13.png)
![](https://it-infrastructure.solutions/content/images/2022/10/grafik-14.png)
![](https://it-infrastructure.solutions/content/images/2022/10/grafik-15.png)
![](https://it-infrastructure.solutions/content/images/2022/10/grafik-16.png)
![](https://it-infrastructure.solutions/content/images/2022/10/grafik-17.png)
Table selection to be synchronized
![](https://it-infrastructure.solutions/content/images/2022/10/grafik-18.png)
![](https://it-infrastructure.solutions/content/images/2022/10/grafik-19.png)
![](https://it-infrastructure.solutions/content/images/2022/10/grafik-20.png)
![](https://it-infrastructure.solutions/content/images/2022/10/grafik-21.png)
![](https://it-infrastructure.solutions/content/images/2022/10/grafik-22.png)
Performing the first synchronization
![](https://it-infrastructure.solutions/content/images/2022/10/grafik-23.png)
![](https://it-infrastructure.solutions/content/images/2022/10/grafik-24.png)
![](https://it-infrastructure.solutions/content/images/2022/10/grafik-26.png)
Expected Result (Cloud (Hub - DB)):
![](https://it-infrastructure.solutions/content/images/2022/10/grafik-27.png)
Link to larger version of the image
References:
Data Sync Agent for SQL Data Sync - Azure SQL Database
Learn how to install and run the Data Sync Agent for SQL Data Sync in Azure to sync data with SQL Server databases
![](https://learn.microsoft.com/en-us/media/logos/logo-ms-social.png)