SqlPackage Publish works, Import does not about dacextensions HOT 3 CLOSED

Have you tried creating the database in advance?

from dacextensions.

It took me a while but after creating the database first, it seems to work OK. I guess I should raise an issue against the docs in that case!

from dacextensions.

@lukos I see that you closed this - but I noticed that you're using sa to run sqlpackage here so the database would be created by the import action.

My guess is that the engine hasn't finished starting up (despite the stackoverflow method).

For what it's worth, my preferred method of checking that the engine is ready to run queries is using sqlcmd to run something like "select * from sys.databases" in a limited loop until it responds. I've been doing this in the past prior to publishing dacpacs and just tested it with importing a bacpac without an issue.
https://github.com/dzsquared/sql-development-tools/blob/main/.devcontainer/mssql/postCreateCommand.sh

from dacextensions.