SQL compare lists stored procs as changed when are the same

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

SQL compare lists stored procs as changed when are the same

Postby lculley2012 » Mon Jul 09, 2012 6:34 pm

I have used red gate compare 6.0 in the past and am evaluating 10 now. I tried using my downloaded copy to compare two sql 2008 servers but it keeps listing procs as having differences when they do not have differences. I tried setting the options to ignore whitespace but it still shows the differences (I confirmed at SSMS that there are no differences). Tried applying a patch to upgrade to 10.2.0.916 and that did not fix the issue. Any ideas? Very dissapointing--I really have loved sql compare in the past.
lculley2012
 
Posts: 1
Joined: Mon Jul 09, 2012 6:29 pm

Postby peter.peart » Wed Jul 11, 2012 10:27 pm

Thanks for your post and sorry you're hitting this. Without any screenshots etc. though, I'm not really going to be able to take this any further I'm afraid.

You're more than welcome to either post them up here, or e-mail support@red-gate.com quoting reference F0062254 with further information and we'll be more than happy to look at this further.

Pete
Peter Peart
Red Gate Software Ltd
+44 (0)870 160 0037 ext. 8569
1 866 RED GATE ext. 8569
peter.peart
Site Admin
 
Posts: 362
Joined: Tue Sep 02, 2008 9:58 am
Location: Top floor, RG towers with the cool kids


Return to SQL Compare 10

Who is online

Users browsing this forum: No registered users and 0 guests