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

Pubblicato il: 08 aprile 2021
sul canale di: 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!

In questa pagina del sito puoi guardare il video online Data sync between SQL on-premises and Azure. Step by step. della durata di ore minuti seconda in buona qualità , che l'utente ha caricato Data friendly 08 aprile 2021, condividi il link con amici e conoscenti, su youtube questo video è già stato visto 10,833 volte e gli è piaciuto 162 spettatori. Buona visione!