[thelist] SQL Server Schema compare tools?

[Kyle Murphy]

Our company currently uses a product called Embarcadero Change Manager
to compare the schema of our DEV Database to over 150 Production
Databases.  

I'm the primary user of this product at my work, and it's ok, but I was
wondering if there are any other products out there that will do the
same thing, so I can see if they are any better.

The basic problem that I have is, when Change Manager is complete
running a compare job, it creates separate SQL scripts for each database
and I have to run each script separately.  I would like something that
generates one giant script with db changes for all 150+ databases...

Anyone have any suggestions?

Thanks,
Kyle