Microsoft Fabric: Import On Premise SQL Server Data into Fabric SQL Database!

Published: 12 December 2024
on channel: Tales From The Field

12,451

156

Azure SQL Database in Microsoft Fabric, aka Fabric SQL Database, aka #FabSQL is here! Now we need to get data into it! In this video Bradley Ball, aka ‪@SQLBalls‬ , guides you through installing an On Premise Data Gateway, connecting it to your #MicrosoftFabric Tenant, and then building a Dynamic Data Pipeline to import the data into Fabric SQL DB!

Chapters
00:00 Dynamic Import for Fabric SQL Database
00:58 Demo Enable Fabric SQL Database at the Tennant
01:36 Demo Create Fabric SQL Database
02:03 Demo Install On Premise Data Gateway
02:52 Demo Create Connection to On Premise SQL Server
03:38 Demo T-SQL Query to Dynamically Get Tables & Schemas
03:58 Demo Create Dynamic Data Pipeline to Import Data
07:18 Demo Validate Data Transfer
08:01 Demo Check the Mirror for Replication

SQL database in Microsoft Fabric (Preview)
https://learn.microsoft.com/en-us/fab...

Microsoft Fabric decision guide: choose a SQL database
https://learn.microsoft.com/en-us/fab...

Install an on-premises data gateway
https://learn.microsoft.com/en-us/dat...

Data Factory documentation in Microsoft Fabric
https://learn.microsoft.com/en-us/fab...

Ingest data into your Warehouse using data pipelines
https://learn.microsoft.com/en-us/fab...

/*******************
/CONNECT WITH US!!
/*******************

Tales from the Field
Twitter:   / talesftfield
Linkedin:   / 100091910
Blusky: https://bsky.app/profile/talesfromthe...

Bradley Ball
Twitter:   / sqlballs
Linkedin:   / sqlballs
Blusky : https://bsky.app/profile/sqlballs.bsk...

Daniel Taylor
Twitter:   / dbabulldog
Linkedin:   / danieltaylor3
Blusky: https://bsky.app/profile/dbabulldog.b...

Neeraj Jhaveri
Twitter:   / neeraj_jhaveri
Linkedin:   / neerajjhaveri
Blusky: https://bsky.app/profile/neerajny.bsk...

Josh Luedeman
Twitter:   / joshluedeman
Linkedin:   / joshluedeman
Blusky: https://bsky.app/profile/joshluedeman...

Andrés Padilla
Twitter:   / nodestreamio
Linkedin:   / andrespadillaandrade

On this page of the site you can watch the video online Microsoft Fabric: Import On Premise SQL Server Data into Fabric SQL Database! with a duration of hours minute second in good quality, which was uploaded by the user Tales From The Field 12 December 2024, share the link with friends and acquaintances, this video has already been watched 12,451 times on youtube and it was liked by 156 viewers. Enjoy your viewing!

1,409