Tools to manage SQL Server database updates?

[edmicman]

We have two production SQL Server db, a handful of development dbs, and a demonstration db. When we make a change in one of our dev instances, basically now we script the changes, then apply them to all the other db's that need it. Are there any tools out there for managing updates to databases, either something that would apply the scripts to everything, or help manage which "version" each db is at, or show differences between them, etc.? Thanks!

 

[edmicman]

some bumpage because I'm still interested 🙂

 

[WannaFly]

Red Gate SQL Bundle sounds like exactly what you are looking for - it cant do "versioning" per se, but it can save snapshots you can compare later. I use it at work - its a great tool, well worth the money.
http://red-gate.com/sql/summary.htm