title: What is a free tool to compare two SQL Server Databases?
body: <p>What is a  free tool to compare two Sql Server tables (data and schema). </p>
  
  <p>It would be great if the tool can script the differences found.</p>
  
  <p>I also went through some older <a href="https://stackoverflow.com/questions/176316/compare-tools-to-generate-update-script-for-sql-server">posts</a>. The closest I have seen is <a href="http://sqldbtools.com/" rel="noreferrer">SQLDBDiff</a> but I would love to try more options.</p>