deploy dacpac in fabric

Question

Hello,I have created a dacpac file once the .sqlproj is built.Now I would like to have this data in dacpac into fabric warehouse environmentcan you guide me on how to migrate the dacpac file into one of the fabric environments, i.e. DEV?thank you

v-nmadadi-msft · Accepted Answer

Hi&nbsp;&nbsp;arkiboys2,Thanks for reaching out to the Microsoft fabric community forum.Please utilize the support for Microsoft Fabric Data Warehouse in the SQL Database Projects extension available inside of&nbsp;Azure Data Studio&nbsp;and&nbsp;Visual Studio Code to migrate the dacpac file into one of the fabric environments.To create a new database project, open Azure Data Studio or Visual Studio Code and navigate to the "Database Projects" section. Click on the "+" button to create a new project, and then select "Synapse Data Warehouse in Microsoft Fabric" as the target platform.To import the .dacpac file, right-click on the newly created project and choose "Import Data-tier Application." Browse and select your .dacpac file, then follow the prompts to import the schema and objects into the project.
After importing, right-click on the project and select "Publish." Enter the connection details for your DEV Fabric Warehouse environment and initiate the publish process to deploy the schema and objects.
Reference document: SQL Projects support for Warehouse in Microsoft Fabric | Microsoft Fabric Blog | Microsoft Fabric
&nbsp;
If you find this post helpful, please mark it as an "Accept as Solution" and consider giving a&nbsp;KUDOS. Feel free to reach out if you need further assistance.Thanks and Regards

Forum Discussion

Related content

Integration Runtime Busy Error When Deploying DACPAC to Warehouse

Deploy Fabric Artefacts with folder structure

CI/CD DACPAC Build Fails (SQL71561) When Views Reference Tables in Another Fabric Lakehouse

Unable to Read Fabric Warehouse/Lakehouse DACPAC using Notepad or any Editor

Deploying a Multi-Schema Warehouse in Fabric