SQL Compare is often used to compare development and production environments to understand what changes need to be pushed to production, as well as any 'ad-hoc' changes made to production that need to be pulled back to the development environment.
If you would benefit from monitoring your databases for schema changes, we would love to hear from you. Please visit the following link to provide your feedback and sign up to our early access program.
http://www.red-gate.com/products/sql_sc ... /index.htm
Red Gate Software