Hi @Toi69___ ,
Thank you for reaching out to the Microsoft fabric community forum.
Yes, you can deploy a single stored procedure from your Dev environment to Prod without redeploying the entire data warehouse. As @NandanHegde mentioned, using a Database Project in SQL Server Data Tools (SSDT) is a good approach. By including only, the specific stored procedure in your project and generating a DACPAC, you can deploy just that object in a controlled and versioned way. This method works well in environments with multiple developers or pipelines.You can refer to the official Microsoft documentation on SQL Server Data Tools - SQL Server Data Tools (SSDT) | Microsoft Learn for more details.
Alternatively, for simple one-off changes, you can extract the CREATE OR ALTER PROCEDURE script from your Dev environment and run it manually in Prod using tools like SSMS or Azure Data Studio. This method is quick and effective but be sure to review and track versions manually. If your Microsoft Fabric workspace is Git-enabled, you can also use Git integration to commit only the updated stored procedure and promote it through Fabric Deployment Pipelines, which helps maintain version control and consistency for more information can be found in the Microsoft Learn article on Overview of Fabric Git integration - Microsoft Fabric | Microsoft Learn
Hope this helps. Please reach out for further assistance.
Thank you.
