SQL file when running update

Hi All,

Is there a way to generate a separate sql file when we run update. I mean i need an sql statements to be  generated for all the changesets that were executed.

UpdateSQL will output what will run, but there isn’t anything currently in place to log everything as it is ran.