SQL Compare 9.0.0.79 Standard: Ignore White Space

Forum for users of SQL Compare schema synchronization utility

Moderators: JonathanWatts, Chris Auckland, David Atkinson

SQL Compare 9.0.0.79 Standard: Ignore White Space

Postby mbranigan » Fri May 31, 2013 11:02 am

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
mbranigan
 
Posts: 4
Joined: Fri May 31, 2013 10:53 am

Postby Brian Donahue » Mon Jun 03, 2013 4:21 pm

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.
Brian Donahue
 
Posts: 6669
Joined: Mon Aug 23, 2004 10:48 am

Postby mbranigan » Tue Jun 04, 2013 9:42 am

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
mbranigan
 
Posts: 4
Joined: Fri May 31, 2013 10:53 am

Postby Brian Donahue » Thu Jun 06, 2013 9:18 am

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?
Brian Donahue
 
Posts: 6669
Joined: Mon Aug 23, 2004 10:48 am

Postby mbranigan » Tue Jul 02, 2013 9:33 am

Hi,
I received no email at all Brian.

Maeve
mbranigan
 
Posts: 4
Joined: Fri May 31, 2013 10:53 am


Return to SQL Compare Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests