Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Did you hear? There's a new SQL AI Developer certification (DP-800). Start preparing now and be one of the first to get certified. Register now

prlangad
‎03-24-2026 01:30 PM

Live connectivity in Migration Assistant for Fabric Data Warehouse (Preview)

If you haven’t already, check out Arun Ulag’s hero blog “FabCon and SQLCon 2026: Unifying databases and Fabric on a single, complete platform” for a complete look at all of our FabCon and SQLCon announcements across both Fabric and our database offerings. 

The live connectivity in Migration Assistant for Fabric Data Warehouse lets you connect directly to your source system and migrate object metadata into a new Fabric warehouse. This preview is designed to help you accelerate the migration and reduce upfront prep by eliminating the need to generate and upload a DACPAC for the metadata step.

Key benefits

  • Start faster: No DACPAC extraction or prep work required to begin metadata migration.
  • Reduce complexity and risk: Fewer manual steps and less chance of schema drift.
  • Keep the guided migration experience: Migration Assistant continues to provide the familiar flow for reviewing outcomes and progressing through migration stages.

What gets migrated (metadata)

Object definitions for schemas, tables, views, stored procedures, functions and security are migrated to the destination warehouse.

How to try it:

  1. Open the workspace > Select Migrate.
  2. Select the source.
  3. Choose the option: Connect directly to the source system.
  4. Provide source connection details.
  5. Select the destination workspace and warehouse.
  6. Migrate.
Screenshot_of_a_software_workspace_interface_displaying_an_empty_task_flow_areaScreenshot_of_a_software_workspace_interface_displaying_an_empty_task_flow_area

Figure 1: Connect directly to the source system.

Important considerations

  • This live connectivity experience is supported for Azure Synapse Analytics Dedicated SQL Pool and SQL Server database, Azure SQL database, or Azure SQL MI used for analytics. Select SQL Server database card for on-premises or cloud SQL database like Azure SQL database or Azure SQL Managed Instance.
  • On-prem SQL Server connectivity may require an on-premises data gateway. If you have existing Power BI gateway, you can leverage it.
  • Metadata visibility depends on permission. If the credentials used to connect don’t have sufficient permissions to read catalog metadata, you may only see a subset of objects available for migration.

Learn more

Labels:
0