title: Visual Studio SSDT Data Compare how to compare two tables in a single database
body: <p>Trying to do something simple Data Compare in SSDT but proving a bit hard.</p>
  
  <p>In one database, I have two tables I want to compare.</p>
  
  <p>These tables have the same schema, just different table names. And I just want to see if this tool will give me a nice way to compare the data in both.</p>
  
  <p>I.e.</p>
  
  <pre><code>tblOutput
  tblOutput_210314
  </code></pre>
  
  <p>But this picking of two tables to compare against each other in a single database I can't see how to achieve.</p>
  
  <p>Seems like you can only pick a table name which exists in both source and target databases. Since my source and target database is the same, I am basically comparing my table to itself ?</p>
  
  <p>Anyone know of a way to achieve this with Data Compare ?</p>
  
  <ul>
  <li>Visual Studio 2012 </li>
  <li>SQL Server Data Tools</li>
  <li>Data Compare</li>
  </ul>