Im try to execute our db unit tests during PR builds. I have a solution with the main database project and a unit test project that references it, plus master. I can run SqlPackage on my local machine but on the build server (in a docker container) I get this:
09:29:35 *** An error occurred during deployment plan generation. Deployment cannot continue.
09:29:35 Error SQL0: The reference to the external element with the name '[sys]|[sys].[indexes].[compression_delay]' could not be resolved. No such element exists.
09:29:35
09:29:35 An error occurred while adding references. Deployment cannot continue.
09:29:35 WARNING: Error in processing the deploy report : SQL Package failed with exit
09:29:35 code 1
09:29:35 Process exited with code 0
Im thinking it cant find the master.dacpac file but it's there.
Anyone seen this before?
Thanks