sql server db on-premise to Azure sql db

Hi,

For on‑prem SQL Server ➜ Azure SQL Database, Microsoft’s recommended approach is to follow the SQL Server → Azure SQL Database migration guidance and choose a method based on downtime.

Recommended Microsoft approach (end‑to‑end):

1. Review migration options & considerations (target selection, tools, downtime, etc.)
   Microsoft Learn: Migration overview: SQL Server to Azure SQL Database
2. Follow the official step-by-step migration guide (includes planning, migration, sync/cutover)
   Microsoft Learn: Migration guide: SQL Server to Azure SQL Database [github.com]
3. Migrate using Azure Database Migration Service (DMS) (official tutorial – offline migration)
   Microsoft Learn: Tutorial: Migrate SQL Server to Azure SQL Database (offline) using DMS [striim.com]

If you specifically want to use Microsoft Fabric for data movement (ETL-style table copy):

1. Use on‑premises data gateway to connect Fabric to on‑prem SQL Server:
   Microsoft Learn: Access on‑premises data sources in Data Factory for Microsoft Fabric [pl.seequality.net]
2. Then use Copy job / pipeline copy to move data into Azure SQL DB:
   Microsoft Learn: How to create a Copy job in Data Factory (Fabric)
   Microsoft Learn: Copy job supported connectors (includes Azure SQL DB)
   Microsoft Learn: Set up Azure SQL Database connection in Fabric
   
   If the solution helps, please accept it as solution. 

Thanks,

Shreya

Hi Koritala,

Thank you for reaching out to Microsoft Fabric Community.

Thank you deborshi_nag and Shreya_Barhate for the prompt response.

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided by the user's for the issue worked? or let us know if you need any further assistance.

Thanks and regards,

Anjan Kumar Chippa