Migrating from SQL Server and Synapse to Azure Databricks
Overview
| Experience | In Person |
|---|---|
| Track | Data Warehousing |
| Industry | Enterprise Technology |
| Technologies | Databricks SQL, Lakeflow, Unity Catalog |
| Skill Level | Beginner |
Learn proven best practices to modernize from SQL Server and Azure Synapse to the Databricks Lakehouse. The session will include Lakebridge's AI‑assisted migration to analyze and convert legacy SQL (T‑SQL DDL/DML, views, stored procedures) and Synapse scripts into Databricks Lakehouse and Spark‑based workloads. Adopt unified governance and privilege mapping in Unity Catalog, and follow a phased cutover: begin with Lakehouse Federation for read‑through access to SQL Server and Synapse, add CDC‑based replication, and run side‑by‑side reconciliation and query validation before switching over. Optionally leverage Lakeflow Connect for managed SQL Server ingestion under Unity Catalog governance. Finally, serve high‑performance BI at scale with SQL Serverless to deliver fast, reliable dashboards in Power BI and beyond. Learn how to de‑risk migrations, improve price/performance, and accelerate delivery.
Session Speakers
Will Girten
/SSA Practice Leader - FinServ
Databricks
Mehran Golestaneh
/SSA
Databricks