Share via

How applying a dacpac file to a Synapse dedicated SQL pool

pmscorca 1,052 Reputation points
2023-12-31T17:16:01.01+00:00

Hi,

I'm implementing a database project inside Visual Studio for a Synapse dedicated SQL pool.

I can applying the .dacpac file related my T-SQL scripts, produced by the build option, using the publish option of Visual Studio; but does it exist another method to apply a .dacpac file to a SQL pool (I don't think to a DevOps pipeline)?

How could I organize my T-SQL scripts in order to manage possible alter operation about a table or view or stored procedure? Thanks

Azure Synapse Analytics
Azure Synapse Analytics

An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.

Answer accepted by question author

Amira Bedhiafi 41,966 Reputation points MVP Volunteer Moderator
2023-12-31T22:52:45.1433333+00:00

If you want to use SSMS, connect to your Synapse dedicated SQL pool and right-click on the database, select "Tasks", and then "Deploy Data-tier Application".

Follow the wizard and select the DACPAC file you want to deploy.

If you want to use SQLPackage Utility to export/import database schema and data so you can deploy a DACPAC to a Synapse dedicated SQL pool using SQLPackage by specifying the appropriate command-line arguments.


SqlPackage.exe /a:Publish /sf:YourDatabase.dacpac /tcs:"YourConnectionString"

Was this answer helpful?

1 person found this answer helpful.
0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. pmscorca 1,052 Reputation points
    2024-01-02T11:32:32.45+00:00

    Hi,

    I can see the "Deploy Data-tier Application" voice selecting "Databases" and not the single database. Thanks

    User's image

    Was this answer helpful?

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.