title: How to get data changes as an update script from two dacpacs
body: <p>From a two .dacpac files I can get the update script using following command</p>
  
  <p>sqlpackage.exe /Action:Script /SourceFile:"C:\Test\bin\Debug\Test.dacpac" /TargetServerName:localhost\DenaliRC0 /TargetDatabaseName:deploy_Test</p>
  
  <p>How ever this will generate only DDL changes (schema changes). But that not included any data changes. Is there anyway I can get those Data changes (DML) from two dacpacs?</p>
  
  <p>Flowing is the java code i use to get schema changes.</p>
  
  <pre><code> CommandLineUtils.execute(this.log, "sqlpackage.exe", new String[]
  {
    "/Action:Script",
    "/SourceFile:" + targetDacPac.getAbsolutePath(),
    "/TargetFile:" + previousDacPac.getAbsolutePath(),
    "/OutputPath:" + scriptOutput.getAbsolutePath(),
    "/TargetDatabaseName:changeme",
    "/p:ScriptDatabaseOptions=False",
    "/p:IgnoreAuthorizer=True",
    "/p:IgnoreLoginSids=False",
    "/p:DropObjectsNotInSource=True",
    "/p:IgnoreFilegroupPlacement=False"
  });
  </code></pre>