title: Creating a CHANGE script in Management Studio?
body: <p>I was wondering if there is a way to automatically append to a script file all the changes I am making to my columns, tables, relationships etc...</p>
  
  <p>The thing is I am doing a lot of different changes on a TEST db and the idea will be to apply this change script when I move the test db to production... hence keeping production data but applying all schema and object changes.</p>
  
  <p>Is there an easy way to do this? Can it also migrate database diagram changes?</p>
  
  <p>I have seen how you can create a change script each time I do a change but this means I have to copy and paste into a master file. Actually pretty easy!</p>
  
  <p>I was just wondering if I was missing something?</p>