title: Comparing two SQL scripts and getting alter script
body: <p>I have two  different Database (say source and target) consisting of 1 Table (Customer, Columns - ID/Name) in both.  Suppose I modify the table in source table and get the updated script and do a comparison with the target table, how can I get the alter script out of them using only <strong>SMO object</strong>.</p>
  
  <p>Is there any way of comparing two script and get the alter script.</p>