search

rr-wfm / MSBuild.Sdk.SqlProj

An MSBuild SDK that provides similar functionality to SQL Server Data Tools (.sqlproj) projects
MIT License
379 stars 42 forks source link

Using SqlCmdVariable in include statements during build time #570

Closed sarvasana closed 2 days ago

sarvasana commented 2 days ago

Example: :r ./folder_a/$(environment_shortname)/dbo.bogus.sql :r ./folder_b/$(environment_shortname)/dbo.foo.sql

Is this possible and if so, how and where do I declare the variable?

ErikEJ commented 2 days ago

According to this it is not possible, and there are suggestions for other ways to achieve this