How do you go about updating (schema changes etc.) sql server databases accross many servers? (including the same server).
Say I have 5 sql server's on seperate boxes, each one having 100 different databases (all for the same application).
Now say version 2.5 is out, and you have to update all the databases to the current schema.
Are there tools where you can point them to the servers and which db's you want to update, and it returns the progress of each database update and reports any errors etc?