Red Gate forums :: View topic - Similar objects shown in differences group
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

Similar objects shown in differences group

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



Joined: 10 Apr 2012
Posts: 2

PostPosted: Tue Apr 10, 2012 9:26 pm    Post subject: Similar objects shown in differences group Reply with quote

I am doing a compare and there are objects being shown in the differences group, but the compare view shows no differences. Am I missing something?
Back to top
View user's profile Send private message
james.billings



Joined: 16 Jun 2010
Posts: 1115
Location: My desk.

PostPosted: Wed Apr 11, 2012 4:14 pm    Post subject: Reply with quote

Just to clarify, are you saying that you highlight the object it found as being different, and the differences pane at the bottom shows nothing highlighted?

If so, I've seen this kind of thing occur before where the only difference is in something like the carriage return type in the extended properties text (i.e. the DB has a CR, the other db (or script file if comparing to scripts) has a CRLF. Because these characters are invisible, nothing gets highlighted.

You can narrow down what the difference is by ticking some of the ignore options- for instance ticking the option to ignore Extended Properties will then treat the objects as identical (assuming the only diff is in those)
Back to top
View user's profile Send private message
cblaze22



Joined: 10 Apr 2012
Posts: 2

PostPosted: Wed Apr 11, 2012 5:24 pm    Post subject: Reply with quote

You are correct. I have all options checked as ignored in the settings but there is no setting called ignore Extended Properties.
Back to top
View user's profile Send private message
james.billings



Joined: 16 Jun 2010
Posts: 1115
Location: My desk.

PostPosted: Wed Apr 11, 2012 5:26 pm    Post subject: Reply with quote

Should be:

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