Iterating through many databases
We have about 3,000 databases that we apply scripts to on a nightly basis. We have a master database that gets all the updates applied to it and then we need to compare the schema's.
So, it's a 1 to many kind of thing. I have 1 master database that I want to compare to 3,000 children to make sure the build went through and all database schemas are exactly the same.
My question is, it takes a few minutes to register a database, and it locks my application. Probly the way I'm coding it, but I don't know a better way at the moment.
How can I get a status message or percent complete when registering databases? Is that possible?