Tools to manage SQL Server database updates?

edmicman

Golden Member
May 30, 2001
1,682
0
0
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!