VisualStudio SQL database project sqlcmdvars TFS deployment override custom File path?
<?xml version="1.0" encoding="utf-8"?>
<SqlCommandVariables xmlns="urn:Microsoft.VisualStudio.Data.Schema.Package.SqlCmdVars">
  <Version>1.0</Version>
  <Properties>
    <Property>
      <PropertyName>Path1</PropertyName>
      <PropertyValue>C:SQLSERVER LOG$(DatabaseName)</PropertyValue>
    </Property>
    <Property>
      <PropertyName>Path2</PropertyName>
      <PropertyValue>C:SQLSERVER DATA$(DatabaseName)</PropertyValue>
    </Property>
  </Properties>
</SqlCommandVariables>

<Property>
  <PropertyName>PathBlobStream</PropertyName>
  <PropertyValue>C:SQLSERVER DATA$(DatabaseName)BlobStream</PropertyValue>
</Property>

ALTER DATABASE [$(DatabaseName)]
    ADD FILE (NAME = [BlobStore], FILENAME = 'C:SQLSERVER DATA####BlobStream') TO FILEGROUP [BlobStreamFileGroup];

<ItemGroup Condition=" '$(Configuration)' == 'Debug' ">
    <Build Include="Schema ObjectsDatabase Level ObjectsStorageFilesBlobStore.sqlfile.sql">
      <SubType>Code</SubType>
    </Build>
  </ItemGroup>
  <ItemGroup Condition=" '$(Configuration)' == 'Internal' ">
    <Build Include="Schema ObjectsDatabase Level ObjectsStorageFilesBlobStore.sqlfile.Internal.sql">
      <SubType>Code</SubType>
    </Build>
  </ItemGroup>