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

Publicado em: 08 Abril 2021
no canal de: 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!

Nesta página do site você pode assistir ao vídeo on-line Data sync between SQL on-premises and Azure. Step by step. duração hora minuto segundo em boa qualidade , que foi baixado pelo usuário Data friendly 08 Abril 2021, compartilhe o link com seus amigos e conhecidos, no youtube este vídeo já foi visto 10,833 vezes e gostou 162 espectadores. Boa visualização!