title: Compare 2 different tables columns from 2 different databases
body: <p>I have a requirement to compare different tables' columns from 2 different databases, in order to add columns to the master tables based on the requirement.</p>
  
  <p>For example:</p>
  
  <p>Assume in master database I have created one table like:</p>
  
  <pre><code>create table test(id int,name varchar(10))
  </code></pre>
  
  <p>Assume in test database I have created one table like</p>
  
  <pre><code>create table testings(id int,name varchar(20), sal int)
  </code></pre>
  
  <p>now I have to compare 2 table columns </p>
  
  <p>I don't want to use red-gate tools.</p>
  
  <p>Can anyone help me?</p>