I’m still very new to Toad. I’ve been given the task of comparing two databases. I’m interested in comparing the database schemas, not the data. The tough thing is that they’re on different Windows Servers, running different versions of SQL Server. (One is SQL Server 2005 and the other is SQL Server 2008 R2.)
So my first question is, can I use Toad Data Modeler 5.4 to do this? And if so, how?
I’ve already reverse engineered both databases and have saved those as .txp files. Do I use those, somehow?