I would like to be able to filter the compare prior to running the actual compare. There are times I only want to compare stored procedures and I do not want to go through all the tables or other objects.
I recently inherited an application. The databases are set up on 6 servers and none of the databases match even though they are used by the same application. There are tables in some databases that are only data tables used for crunching numbers. There are thousands and I do not need SQL Compare to run through each one - in fact, I get memory errors when trying to run the compare.
It would be useful to be able to compare stored procedures or selected list of tables in order to develop a common structure used by all.