Executing embedded migration not using SQLCMD variables

christianacca

I am running embedded migrations as per the help docs: https://documentation.red-gate.com/disp ... d+Resource

I'm finding that the SQLCMD variables that I've defined in my ReadyRoll project are not being used. Please don't say I have to reinvent the same mechanism that ReadyRoll would be doing for me?!?

I think I know the answer to that. So the next question is - can you provide a sample that I could use that would read the variables from the .sqlproj.user and then .sqlproj files to populate the SqlCmd.

Thanks
Christian

dnlnln

Hi Christian,

You're quite correct about that limitation, unfortunately. The embedded deployment functionality is still fairly new so we haven't got to filling that functionality gap just yet.

The variable values from the project are actually inserted into the header of the SQLCMD package file at build time, but commented out. If you'd like to use them, it's just a matter of "un-commenting" them in the script prior to deployment. Does that help at all?

christianacca

Yes I noticed the commented out variables.

My action plan is therefore:

1. Use the commented out variables when running the embedded migrations on a developer machine
2. Create a custom section in the web config to read the variable values from for all other deployments (values will vary per environment)

As a side note, the open source tool used to execute the embedded migrations (https://www.nuget.org/packages/com.rusanu.DBUtil/) has a limitation which means the variables included in the header of the script fails to produce the correct variable substitution at runtime.

This is fixed in a fork of the DBUtil project's repo (https://github.com/AdamDee/com.rusanu.dbutil/pull/1), but this is not available on nuget. In the meantime, that means everyone who goes this route will need to cut their own nuget package from the source of the above pull request.

C

dnlnln

That's no good, thanks for highlighting the issue with qualifiers in DBUtil's variable handling.

I'll follow up with the author of the DBUtil project in the next few days if there hasn't been a response to your comment on the PR.

christianacca

I have submit the PR that fixes the problem to the official DbUtil repo (see https://github.com/rusanu/com.rusanu.dbutil/pull/4)

It just needs merging and a new nuget package cut and published from the merged source.

Can you ask the author to do this.

Thanks
Christian

dnlnln

Thanks Christian, I will follow up with the project owner in the next few days.

dnlnln

Your PR has been merged and Remus has pushed a new version of the utility to NuGet.org.

Please let me know how you get on.

christianacca

Thanks

dnlnln

You're welcome! Please let me know if there's anything else I can help with.