Migrating from Azure SQL Managed Instance o Elastic pools to Fabric

[pmscorca]

Hi,

I'm evaluating to migrate some Azure SQL Managed Instances and Elastic Pools to Fabric.

Which is the proper workload in Fabric? Fabric SQL Database?

After the data migration from Azure, the purpose is to operate with the corresponding Fabric workload.

What does Fabric SQL Database support? Stored procedures? User-defined functions? Views?

Copilot doesn't provide me more information about this subject.

Any suggests to me, please? Thanks

[akatesmith]

Hi @pmscorca 

SQL database in Fabric is currently in public preview on the Fabric platform.  It is fully integrated with the Fabric platform - from OLTP SQL engine to the analytics endpoint to the lakehouse.  

Here is the documentation for our product: 

SQL database Overview (Preview) - Microsoft Fabric | Microsoft Learn

And some additional information about creating reports: 

Create reports on your SQL database in Power BI - Microsoft Fabric | Microsoft Learn

You can leverage direct lake query mode by connecting to the SQL analytics endpoint, which is automatically populated when you create a SQL database in Fabric.  This document contains more information:

https://learn.microsoft.com/en-us/fabric/fundamentals/direct-lake-overview 

--Kate

[pmscorca]

Hi @akatesmith 

reading the article Direct Lake overview - Microsoft Fabric | Microsoft Learn

it seems that Direct Lake isn't supported by a Fabric SQL Database.
What can you reply about it?

[v-achippa · Accepted solution]

Hi @pmscorca,

Thank you for reaching out to Microsoft Fabric Community.

Based on your requirement, you can use the Fabric Data Warehouse for analytics and reporting or Lakehouse with SQL Analytics Endpoint for data lake and analytics scenarios.

After migrating from Azure, the best matching workload in fabric for sql operations is the Fabric Data Warehouse.

Fabric Warehouse supports T-SQL based views, scalar and inline table valued UDF’s and Stored procedures (with some limitations)

It does not support Sql Agent, CLR or cross database queries.

Please refer below official documentation for more details:

https://learn.microsoft.com/en-us/fabric/data-engineering/lakehouse-overview#lakehouse-sql-analytics...

https://learn.microsoft.com/en-us/fabric/data-warehouse/tsql-surface-area

https://learn.microsoft.com/en-us/fabric/data-engineering/lakehouse-sql-analytics-endpoint

If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it! 

Thanks and regards,

Anjan Kumar Chippa

[pmscorca]

Hi @v-achippa , why is Fabric SQL database not the proper workload?

[v-achippa]

Hi @pmscorca,

Currently the SQL database in Fabric is in public preview.

SQL database Overview (Preview) - Microsoft Fabric | Microsoft Learn

Alternatively, if you are referring to SQL based capabilities in fabric, the closest equivalents are the Fabric Data Warehouse or the Lakehouse SQL Analytics Endpoint.

Microsoft Fabric is an end-to-end analytics platform designed for analytical (OLAP) workloads not for transactional (OLTP) workloads like Azure Sql Database or Managed Instance.

If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it! 

Thanks and regards,

Anjan Kumar Chippa

[v-achippa]

Hi @pmscorca,

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution I have provided for the issue worked? or let us know if you need any further assistance.
If my response addressed, please mark it as "Accept as solution" and click "Yes" if you found it helpful.

Thanks and regards,

Anjan Kumar Chippa

[pmscorca]

Hi,

I've posted this my idea Fabric SQL database has to support fully Power BI - Microsoft Fabric Community