Missing values ​​for the following SqlCmd variables: Path1 Path2

Question

I get an error

Missing values ​​for the following SqlCmd variables: Path1 Path2.

in several Sql projects in Visual Studio.

I tried googleling but found nothing.

Answer 1

Select an SQL project. Go to the project properties (ALT + Enter). Go to the SQLCMD variables and act accordingly (delete the variables or fill in the default values).

Answer 2

This happened to me, and it turned out that someone else had set up automatic logging in a project that matched the path variable in sqlcmd variables. After they registered in tfs, I could no longer build due to this error. Ask them to clear the path and update the project or match the variable value on your side.

Answer 3

I came across this yesterday after changing the project settings for my database project (right-click the database project, click properties, then click Project Settings).

I checked the Create script parameter (.sql file) and everything continued to work as usual for me. But when another team member checked the last update, they could not build and received an error about missing values ​​for SqlCmd variables. It still worked for me until I checked the new version of the source and started getting the same error.

To fix, I just turned off the Create script (.sql file) option and everything was fine again.

Answer 4

I hit this problem. I added some SQLCMD variables and deleted them. SQLCMD variables no longer exist in publication files or in a .sqlproj file. I collected all the files in the project, and the variables did not exist anywhere. I restarted Visual Studio. However, I was still getting Missing values ​​for the following SqlCmd variables: error.

From the project directory, I deleted the * .dbmdl and * .sqlproj.vspcc files. Then the project was successfully published.