How to generate NuGet package version as per the build format with suffix

SR123

I  was using Redgate SQL change automation build and Publish tasks in TFS. How can we produce NuGet package version as $(MajorVersion).$(MinorVersion)$(rev:.r).$(PatchVersion) -Main(ex: TestDB.1.0.0-Main.nupkg. I want create a Release octopus deploy with that format.



Thanks

TheMaskedData

@SR123 you should be able to specify the name of the output file when creating the NuGet package from the SQL Change Automation Build.

You should then be able to pass in TFS / Azure DevOps variables or project variables into the naming.

Pipelines variables: Define variables - Azure Pipelines | Microsoft Docs and pre-defined environment variables: Predefined variables - Azure Pipelines | Microsoft Docs