Visual Studio SSDT Data Compare how to compare two tables in a single database <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>