Red Gate forums :: View topic - SQL Compare 9.0.0.79 Standard: Ignore White Space
Return to www.red-gate.com RSS Feed Available

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

SQL Compare 9.0.0.79 Standard: Ignore White Space

Search in SQL Compare Previous Versions forum
Post new topic   Reply to topic
Jump to:  
Author Message
mbranigan



Joined: 31 May 2013
Posts: 4

PostPosted: Fri May 31, 2013 11:02 am    Post subject: SQL Compare 9.0.0.79 Standard: Ignore White Space Reply with quote

Hi there,

In SQL Compare 9.0.0.79 Standard if I do a comparison between two databases and select "Ignore Whitespace" the upper pane continues to display tables and objects that contain white space differences. The whitespace will only ignored int he lower pane.

Hence, I see a list of tables int he top pane that contain whitespace

Table 1
Table 2
Table 3

If I click on Table 1, the DDL for table 1 is displayed in the lower pane. If I scroll down there is no difference at all identified.

I would have expected that both panes would behave consistently, that if "Exclude Whitespace" was ticked, then BOTH panes would be affected.

Please let me know if there is a way to avoid this. If we upgrade to the latest version of SQL Compare will this issue be avoided.

Many Thanks

Maeve
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6582

PostPosted: Mon Jun 03, 2013 4:21 pm    Post subject: Reply with quote

Hi Maeve,

If there is whitespace in the actual object name, I don't believe "ignore whitespace" has any effect - because the object names do not match, this would not work as you would not be comparing the same object.

In SQL Compare v10, you can map differently-named tables together, so that may work around the issue.
Back to top
View user's profile Send private message
mbranigan



Joined: 31 May 2013
Posts: 4

PostPosted: Tue Jun 04, 2013 9:42 am    Post subject: Reply with quote

Hi Brian,
The whitespace is not in the name of the table. The whitespace is in the comment on the table. So, it is the extended properties.

If you read my question. It states that when whitespace is ticked that whitespace will only ignored in the lower pane. Surely the upper pane and the lower pane should be consistent.

Maeve
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6582

PostPosted: Thu Jun 06, 2013 9:18 am    Post subject: Reply with quote

Sorry, I didn't know what you meant by upper pane and lower pane. I assume upper pane is the list of objects.

You should have got an email from us about this forum post being raised as a support call. Can you reply to that with some screenshots?
Back to top
View user's profile Send private message
mbranigan



Joined: 31 May 2013
Posts: 4

PostPosted: Tue Jul 02, 2013 9:33 am    Post subject: Reply with quote

Hi,
I received no email at all Brian.

Maeve
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