title: How do I customise the CREATE DATABASE statement in VSTS DB Edition Deploy?
body: <p>I'm using VSTS Database Edition GDR Version 9.1.31024.02</p>
  
  <p>I've got a project where we will be creating multiple databases with identical schema, on the fly, as customers are added to the system. It's one DB per customer. I thought I should be able to use the deploy script to do this. Unfortunately I always get the full filenames specified on the CREATE DATABASE statement. For example:</p>
  
  <pre><code>CREATE DATABASE [$(DatabaseName)]
  ON 
  PRIMARY(NAME = [targetDBName], FILENAME = N'$(DefaultDataPath)targetDBName.mdf')
  LOG ON (NAME = [targetDBName_log], FILENAME = N'$(DefaultDataPath)targetDBName_log.ldf')
  GO
  </code></pre>
  
  <p>I'd expected something more like this </p>
  
  <pre><code>CREATE DATABASE [$(DatabaseName)]
  ON 
  PRIMARY(NAME = [targetDBName], FILENAME = N'$(DefaultDataPath)$(DatabaseName).mdf')
  LOG ON (NAME = [targetDBName_log], FILENAME = N'$(DefaultDataPath)$(DatabaseName)_log.ldf')
  GO
  </code></pre>
  
  <p>Or even </p>
  
  <pre><code>CREATE DATABASE [$(DatabaseName)]
  </code></pre>
  
  <p>I'm not going to be running this on an on-going basis so I'd like to make it as simple as possible, for the next guy. There are a bunch of options for deployment in the project properties, but I can't get this to work the way I'd like.</p>
  
  <p>Any one know how to set this up?</p>