Is there a way that I can do a live compare without all the sync options of SQL Compare??
That would be the best tool ever for me.
I don't need to sync them, I just need to know if they're different from our baselines.
Yes yes...I know...it's an ungodly number of databases...even Microsofts eyes get big when we tell them how many we have to manage.
So anyway, I digress...Is there a simple tool for that? I've been trying to write my own with the SQLCompare API's, but...it's kind of...slow because I don't want it to generate all the change code...just show me that I have differences, like the table name and owner or stored proc, but not tell me all the syscomments text and all the differences between our baseline and the target db. I can use SQLCompare later for that.