Data sync between SQL on-premises and Azure. Step by step.

This tutorial will show you how to configure data sync between Azure and on-premises SQL servers. Step by step, with detailed explanations. -------------------------------------------- TABLE OF CONTENTS -------------------------------------------- 00:00 - Introduction 01:29 - Azure preparation. Creating a new database. 03:43 - Azure DB sync configuration 06:36 - Creating a new user in the new database 09:46 - Permission set up for the new user 11:26 - Sync agent installation and configuration 15:10 - Troubleshooting failed connection in Sync agent 16:21 - Registering on-premises server 17:36 - Opening port for the Sync Agent and synchronization 18:52 - Adding database in Azure 20:54 - Selecting the tables for the synchronization 24:26 - Checking if synchronization is working as expected 26:30 - Removing tables, procedures, and everything else that was created during configuration 33:20 - Thank you for watching! 34:30 - Fails Like my video? Patreon link to support me, get extra perks, and download files I have created in my videos:   / datafriendly   Gear I use: Camera: https://amzn.to/30G0Ecp Monitor: https://amzn.to/3kmrFtv Laptop: https://amzn.to/33H49kV External HDD I recommend: https://amzn.to/2PFgMEO *I use affiliate links on the products that I recommend. These give me a small portion of the sales price at no cost to you. I appreciate the proceeds and they help me to improve my channel!