title: Compare two tables with different schema in SQL Server
body: <p>I have two tables in different databases with different schema, how can I compare them both? </p>
  
  <p>Let's say I have the <code>DB1</code> with the table <code>history.Table1</code> and another <code>DB2</code> with the same table but in a different schema, <code>backup.Table1</code>.</p>
  
  <p>Now I need to compare what's different besides the schema name obviously. </p>