[New article]: Executing a Dacpac during Sql Container Provisioning #1582
Labels
doc-idea
Indicates issues that are suggestions for new topics [org][type][category]
⌚ Not Triaged
Not triaged
Proposed topic or title
Executing a Dacpac during Sql Container Provisioning
Location in table of contents.
/database/execute-dacpac.md
Reason for the article
A lot of developers are embracing the SqlPackage approach for doing incremental updates on databases. This allows them to put their SQL code in source control using SQL Projects and manage SQL changes in a more controlled fashion. It is important for Aspire to support this in a simple way that they can easily implement.
Article abstract
In this article, you will learn to configure Aspire to publish a SqlPackage DACPAC file against a SQL Server container as part of the startup process.
Relevant searches
I dug through these documents, a few other repos, including some Aspire Dev Days repos, and some chatter on X and StackExchange from the various developers involved in Aspire, but nobody got it working and documented it.
Specifically, what I did to get it working was the following:
For the SqlContainer setup:
For the Docker File itself:
The entrypoint.sh was similar to your example for seeding the DB. The configure-db.sh is different, though:
Hope this helps!
The text was updated successfully, but these errors were encountered: