I’m still pretty new with Toad for SQL Server (or any database for that matter). I’ve been tasked with comparing two databases’ schemas, but they’re on different servers. And not only that but the version of SQL Server is different on each of these servers. (One is SQL Server 2005 and the other is SQL Server 2008 R2, although the second server might go to SQL Server 2012.)
So the first question is, can Toad for SQL Server do this sort of comparison?
Secondly, if the answer to the first question is yes, then how do I do it?