Forum Discussion

DebbieE's avatar
DebbieE
Community Champion
9 months ago
Solved

Fabric SQL Database and Visual Studio Project

Just been through all the documentation and it hasnt helpe but i guess everything is new.    I am trying to figure out how to include the Fabric SQL Database and I went through the motions of setti...
data engineering
  • OnurOz's avatar
    OnurOz
    9 months ago

    Hi DebbieE 

    If I've understood you correctly, to deploy SQL changes into a Fabric SQL Database that is under source control, you should use the Fabric deployment flow. Change your database code, commit to git (if necessary PR into fabric's branch), then use Source Control => Updates => “Update all” in Fabric UI. Then the item state is applied to the SQL Database.

    I guess it publish a SQLproj directly to Fabric SQL Database is not always working ideally, although you could use SqlPackage.exe (with /p:AllowIncompatiblePlatform=true)

    I recommend checking this page: SqlPackage for SQL database - Microsoft Fabric | Microsoft Learn and this one: Fabric SQL database source control integration - Microsoft Fabric | Microsoft Learn

    Hope that helps

    Onur

    😊If this post helped you, feel free to give it some Kudos! 👍

    ✅And if it answered your question, please mark it as the accepted solution.

DebbieE's avatar
DebbieE
Community Champion
9 months ago

 OK so I am getting through to this message  

Deploy dacpac: Failed. Could not deploy package. Warning SQL72015:  Msg 368, Level 14, State 1, Line 1 The external policy action 'Microsoft.Sql/Sqlservers/Databases/Schemas/Tables/Create' was denied on the requested resource. Error SQL72045: Script execution error. The executed script: CREATE TABLE [metadatafwk].[tmp_ms_xx_bronze_audit] 
 
So I know some have you have said it works but it doesnt for me. this is something I have maybe found 
 
Unfortunately, dacpac incremental publish is not fully supported for Fabric SQL DB because of these restrictions.  I am basically the workspace admin so i shouldnt have a problem? 
 
Anyway. It would be good to know if there is something I can do or if Fabric SQL DB isnt quite up to speed yet because I havent been able to deploy