Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more
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 environment
can you guide me on how to migrate the dacpac file into one of the fabric environments, i.e. DEV?
thank you
Solved! Go to Solution.
Hi @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 Azure Data Studio and 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
If you find this post helpful, please mark it as an "Accept as Solution" and consider giving a KUDOS. Feel free to reach out if you need further assistance.
Thanks and Regards
Hi @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 Azure Data Studio and 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
If you find this post helpful, please mark it as an "Accept as Solution" and consider giving a KUDOS. Feel free to reach out if you need further assistance.
Thanks and Regards
Check out the March 2025 Fabric update to learn about new features.
Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.
User | Count |
---|---|
11 | |
4 | |
2 | |
1 | |
1 |
User | Count |
---|---|
6 | |
4 | |
4 | |
3 | |
3 |