We have a SQL Server Visual Studio Database Project in Source Control. We have 10 databases in the solution. We build all database projects together, since there are dependencies/cross joins etc. Then depending on which file/project is changed, we want to conditionally deploy to 10 different Octopus projects.
1 Source Control ---> 1 Teamcity Build ---> 10 Octopus Deploy Projects
Eg: if it notices a file called eg ProductDatabase.sqlproj in %changedFiles.file%, then OctopusDeployCreate-Release to OctopusProduct
Eg if it notices a file called eg CustomerDatabase.sqlproj in %changedFiles.file%, then OctopusDeployCreate-Release to OctopusCustomer.
How would I create a conditional build step for OctopusDeploy-CreateRelease in Teamcity using %changedFiles.file%?