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

Veröffentlicht am: 08 April 2021
auf dem Kanal: 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!

Auf dieser Seite können Sie das Online-Video Data sync between SQL on-premises and Azure. Step by step. mit der Dauer stunde minuten sekunde in guter Qualität ansehen, das der Benutzer Data friendly 08 April 2021 hochgeladen hat, den Link mit Freunden und Bekannten teilen, dieses Video wurde auf Youtube bereits 10,833 Mal angesehen und es wurde von 162 den Zuschauern gefallen. Viel Spaß beim Betrachtenden Zuschauern gefallen!