Hello, please let me know what I’m missing. I’m using SQL Server 2008 R2 and am comparing two data models. In the Sync & Convert Wizard window, I have Show Unequal Objects and Show Unequal Properties selected. There are many stored procedures in the list that are exactly the same in both models. I expand a stored proc, see the SQL property, and see some SQL code for each model in blue text. I double click on the SQL code and new window comes up, Object sp_name Property SQL. The two stored procedures are exactly the same.
I then choose a stored procedure I know to be different between the two models. It looks exactly the same as the previous one in the wizard window. But, in the property window, I see the differences.
Is there a way to have the compare only show me those stored procedures that have different SQL?