Red Gate forums :: View topic - SQL Differences pane - inconsistent results at first glance
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Compare 10
SQL Compare 10 forum

SQL Differences pane - inconsistent results at first glance

Search in SQL Compare 10 forum
Post new topic   Reply to topic
Jump to:  
Author Message
jela



Joined: 04 Dec 2013
Posts: 7

PostPosted: Mon Feb 10, 2014 11:25 am    Post subject: SQL Differences pane - inconsistent results at first glance Reply with quote

Hello Red Gate team,

earlier today I did a compare of two databases and wondered about the results shown in the SQL Differences pane. So for example in line 50 of the target table a column is listed, which is marked for dropping whereas it is also listed in the source table in line 53 (it's a bit hard to explain).

The Deployment Wizard does get it right, though. The deployment script does not show any changes for the column in question.

I noticed the 'Example: ignoring column order' entry stating that changes would still be highlighted (when ignoring the column order), even if the tables would be marked as identical. So I wondered, whether my 'problem' is really by design. But nevertheless it is confusing, if one is only looking for changes made in the source database and is shown more than the expected difference(s).

I couldn't find any options in 'Edit Project' settings, which seemed to change this behaviour. Is there something I missed or are there any plans to change the default behaviour?

Kind regards,
Jens
Back to top
View user's profile Send private message
Manfred.Castro



Joined: 23 Apr 2012
Posts: 209

PostPosted: Wed Feb 12, 2014 6:46 pm    Post subject: Reply with quote

When SQL Compare compares a schema, a semantic comparison will be performed (top grid) which will group the objects based on the rules you have applied to the deployment and other basic functionally similar syntax that will automatically be ignored. It is these differences that will be deployed.

The other comparison is a straight textual comparison, that will be displayed in the bottom SQL Differences pane. All textual differences will be highlighted here. We can try match the rows as best we can, but each method will have its limitations and we don't think it would be right to reorder the SQL at this stage.

http://documentation.red-gate.com/display/SC10/SQL+Compare+shows+identical+objects+as+different#

This is designed behavior and there are no plans to change the default behaviour.
_________________
Manfred Castro
Product Support
Red Gate Software
Back to top
View user's profile Send private message
jela



Joined: 04 Dec 2013
Posts: 7

PostPosted: Thu Feb 13, 2014 9:38 am    Post subject: Reply with quote

Hello Mr. Castro,

I wasn't aware, that there alreday existed a documentation entry regarding the topic of this threat - thanks for pointing that out.

The way I read your reply and the documenattion entry, I would assume, that both comparisons (semantic and textual) are carried out during the comparison phase. Would it be possible to highlight semantic differences in another colour? That way there wouldn't be a need to reorder the SQL statements, but one would still be able to spot 'real' differences more easily.

Thanks for your help, it's much appreciated.

Kind regards,
Jens
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group