title: SqlPackage.exe ignores its CreateNewDatabase property?
body: <p>In VS 2013, have two SSDT composite projects that target the same database:</p>
  
  <ul>
  <li>The 1st project is responsible for the target database itself.</li>
  <li>The 2nd project has a database reference to the 1st project and is responsible for test data in the target database.</li>
  </ul>
  
  <p>When I deploy the 2nd project, I <em>only</em> want to update the target database as needed, <em>never</em> drop/create it.</p>
  
  <p>To deploy the 2nd project, I am attempting to use <a href="http://msdn.microsoft.com/en-us/library/hh550080%28v=vs.103%29.aspx" rel="nofollow"><code>SqlPackage.exe</code></a> as follows to generate a deployment script:</p>
  
  <pre><code>C:\some\directory\ssdt\sqlpackage.exe ^
      /a:Script ^
      /op:".\BlahTest.sql" ^
      /sf:".\BlahTest.dacpac" ^
      /tsn:"localhost" ^
      /tdn:"BlahTest" ^
      /p:CreateNewDatabase="False" ^
      REM ...
  </code></pre>
  
  <p>I expected <code>/p:CreateNewDatabase="False"</code> to mean that I would not find <code>DROP DATABASE</code> or <code>CREATE DATABASE</code> in <code>BlahTest.sql</code>; but I see the following irrespective of the <code>CreateNewDatabase</code> property (i.e. set to <code>"False"</code>, set to <code>"True"</code>, or omitted):</p>
  
  <pre><code>USE [master];
  
  
  GO
  
  IF (DB_ID(N'$(DatabaseName)') IS NOT NULL) 
  BEGIN
      ALTER DATABASE [$(DatabaseName)]
      SET SINGLE_USER WITH ROLLBACK IMMEDIATE;
      DROP DATABASE [$(DatabaseName)];
  END
  
  GO
  PRINT N'Creating $(DatabaseName)...'
  GO
  CREATE DATABASE [$(DatabaseName)]
      ON 
      PRIMARY(NAME = [$(DatabaseName)], FILENAME = N'$(DefaultDataPath)$(DefaultFilePrefix)_Primary.mdf')
      LOG ON (NAME = [$(DatabaseName)_log], FILENAME = N'$(DefaultLogPath)$(DefaultFilePrefix)_Primary.ldf') COLLATE SQL_Latin1_General_CP1_CI_AS
  GO
  </code></pre>
  
  <p>How can I get <code>SqlPackage.exe</code> to output a script that does not drop/create the target database?</p>