Hosting.SqlDatabaseProjects: How to restore the data from a bacpac?

[johanndev]

I'm currently testing the Hosting.SqlDatabaseProjects package in conjunction with an sqlproj. The WithDacpac method works perfectly to restore the schema, so I'm curious: Is there a way to import an bacpac file that includes the table data? I would want to only run the import in run mode, during development.

And thanks to all contributors :)

[ErikEJ]

This is a duplicate of sorts of #337

Could you use a postdeploy script with merge statements instead?

There are variuos tools out there to make them easy to create.

[johanndev]

Sorry - I saw the issue by Egil was marked as "Not planned" and did not realize that he has prepared a complete implementation.

Thank you.

[ErikEJ]

@jmezach Thoughts? IMHO seems not related to SQL Projects ?

[jmezach]

@ErikEJ I'd say it is related since you can use SqlPackage to create a .bacpac as well so I wouldn't be against adding the ability to import a .bacpac during local development with Aspire. That being said I've never used these files myself, but from what I understand you can easily export a database in a .bacpac from the Azure Portal for example. I can see a use case for having the ability to export say a test database and importing that on your dev machine can certainly improve the developer experience. But perhaps it would be best served as a separate package?