Comparing using command line show different but not in GUI

Compares and synchronizes SQL Server databases, backups and scripts.

Moderators: JonathanWatts, Chris Auckland, David Atkinson, eddie davis, Anu Deshpande, Michelle Taylor, alice.easey, james.billings, chengvoon.tong

Comparing using command line show different but not in GUI

Postby rre » Wed Sep 05, 2012 12:51 pm

When I comparing a snapshot folder with a database using the command line I getting differences, but there were identical and no differences were highlighted. For that I was using the following parameters in a special XML file:

Code: Select all
<options>IgnoreWhiteSpace,IgnoreConstraintNames,IgnorePermissions,IgnoreQuotedIdentifiersAndAnsiNullSettings</options>


After looking at the comparison report which is also generated by SQL Compare it shows me some objects with differences, but actually there looked identical.

Well, I try with the SQL Compare GUI and used the the same parameter I had used via the command line. The results was that it shows me no differences. Ok, this means is has something to do with the command line version of SQL Compare.

Well, after playing around with some parameters I tried to use the same constraint names in my snapshot folder and my target database to avoid this differences in general although I used the particular option to ignore it. After renaming the constraints on both targets my problem was solved.

I like to share my experience with this strange behavior of the command line from SQL Compare. May be you can reproduce it your environment.
If you need any further information, please let me know.

I used SQL Compare Version 10.2.0.1337
rre
 
Posts: 30
Joined: Thu Jul 07, 2011 2:13 pm

Postby stanori » Fri Sep 07, 2012 8:32 pm

Hi rre,

Thanks for your post. We have opened a support ticket for you in regards to this issue. I will be in contact with you shortly.

Regards,
Steve
_________________
Steve Tanori
Product Support
Red Gate Software Ltd.
866-997-0378
stanori
 
Posts: 84
Joined: Mon Apr 23, 2012 1:13 pm


Return to SQL Compare 10

Who is online

Users browsing this forum: No registered users and 0 guests