Error when "restore database from URL" encountered in sql files about msbuild.sdk.sqlproj HOT 7 CLOSED

Please share your project (at least options)

from msbuild.sdk.sqlproj.

I would expect the original .sqlproj to fail with the same error actually, since both project file formats should be using the same SQL parser. Unless the offending file is not part of the build in the original .sqlproj. What is the build action for that file?

Either way I don't think there's much we can do here if the parser doesn't support it. I checked if there's an update to the NuGet package we're using, but alas there's no newer stable version.

@ErikEJ I've added the suggested workarounds to the README so I think we can go ahead and close this.

from msbuild.sdk.sqlproj.

The work in progress is here: https://github.com/SkillsFundingAgency/dfc-coursedirectory/blob/linux-builds/src/Dfc.CourseDirectory.Database.Build/Database.Build.csproj (work in progress branch, may disappear later)

It pulls in https://github.com/SkillsFundingAgency/dfc-coursedirectory/tree/cd887928fb48e08cafcd8c34eac8d207ebe283f0/src/Dfc.CourseDirectory.Database

from msbuild.sdk.sqlproj.

I had a look around and according to this post it seems that it is also an issue with the existing .sqlproj format. @timabell Does the .sqlproj compile as it is, or does it give you the same error?

The post linked above suggests to use dynamic SQL to resolve it, although that is of course less ideal.

from msbuild.sdk.sqlproj.

Or maybe move the offending script to PostDeployment with "CREATE OR UPDATE" ?

from msbuild.sdk.sqlproj.

@jmezach The visual studio sqlproj does compile and create a dacpac, yes.

I tried the dynamic sql option and that indeed get past the error though at a cost of the ability of tooling to analyse the file.

I've realised I probably don't actually need that script in the linux build of the dacpac for local development at the moment so I've altered my linux build csproj to not include the problematic folder and now have a successful build. Thanks for your help on this.

@ErikEJ thanks for the suggestion, I didn't get as far as trying it.

I don't know if it makes sense to keep this issue open as I'm not that familiar with dacpacs and don't know if a database restore would be a normal thing to keep in them. I may return here if I end up needing it as part of the build setup later.

Thanks again, very grateful for the quick and helpful responses.

from msbuild.sdk.sqlproj.

Agree, not something this project can fix - we should keep eyes on updates to the NuGet pckage, but I do that regularly anyway for EF Core Power Tools.

from msbuild.sdk.sqlproj.