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

Publié le: 08 avril 2021
sur la chaîne: Data friendly

10,833

162

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!

Sur cette page du site, vous pouvez voir la vidéo en ligne Data sync between SQL on-premises and Azure. Step by step. durée heure minute seconde en bonne qualité , qui a été Téléchargé par l'utilisateur Data friendly 08 avril 2021, Partagez le lien avec vos amis et connaissances, sur youtube cette vidéo a déjà été regardée 10,833 fois et il a aimé 162 téléspectateurs. Bon visionnage!