Issues with new Release 10.2.0.696

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

Issues with new Release 10.2.0.696

Postby skuhn » Wed May 23, 2012 3:09 pm

I recently upgraded to the latest version, 10.2.0.696 and when performing a compare SQL Compare is showing over 200 tables as "existing in both but different". Since we have made very few changes this was very surprising. When I look at the side by side comparison at the bottom, SQL Compare is showing no actual differences on the vast majority of tables.

The compare is performed using Source Control to Database compare for migration to TEST. (Within the source control option I have chosen our DEV database which is linked to source control and the compare is to our TEST database.)
skuhn
 
Posts: 19
Joined: Fri Dec 30, 2011 4:45 pm

Postby neil.anderson » Wed May 23, 2012 3:21 pm

Hi Skuhn,

Can you try the patch build from here:

ftp://support.red-gate.com/patches/sql_ ... .0.777.zip

and let me know if it fixes your problem?

Thanks,
Neil
neil.anderson
 
Posts: 64
Joined: Tue Sep 28, 2010 2:17 pm

SQL Compare Patch

Postby skuhn » Wed May 23, 2012 3:37 pm

Hi Neil,

Yes, that solved my problem. Thank you very much for the quick response!

Scott Kuhn
skuhn
 
Posts: 19
Joined: Fri Dec 30, 2011 4:45 pm

Postby DLDM » Thu May 24, 2012 8:02 pm

Hi, Neil,

I was seeing the same problem. I installed the patch and it fixed that particular problem.

However on a related note, the patch version still appears to be falsely reporting changes for some Stored Procedures that have not changed. Either there are differences that aren't being highlighted, or there aren't any differences and the SP should not have been flagged as changed.
-Dave
DLDM
 
Posts: 1
Joined: Thu May 24, 2012 7:31 pm

Broken 10.2

Postby Michael Newcomb » Tue May 29, 2012 3:22 pm

I'm having lots of problems with 10.2.0.696 (now upgraded to 10.2.0.777). SQL Compare is showing hundreds of differences between databases that have only minor changes -- if you click the "changed" items no differences show in the compare window.

Further, SQL Compare started popping a window that says it has "magically mapped the following fields." The mapping it shows makes absolutely no sense and seems random, but I can't figure out how to undo it or to stop it from doing anything magically.

Is there any way I can roll back to the old version? I can't use the product in its current state.

Thanks for your help,

Mike N.
Michael Newcomb
 
Posts: 2
Joined: Wed Mar 19, 2008 4:06 pm

Re:

Postby neil.anderson » Tue May 29, 2012 5:18 pm

[quote="DLDM"]Hi, Neil,

I was seeing the same problem. I installed the patch and it fixed that particular problem.

However on a related note, the patch version still appears to be falsely reporting changes for some Stored Procedures that have not changed. Either there are differences that aren't being highlighted, or there aren't any differences and the SP should not have been flagged as changed.
-Dave[/quote]

Hi DLDM,

Can you give me an example of a SP that you Compare is showing as different now?

Thanks,
Neil
neil.anderson
 
Posts: 64
Joined: Tue Sep 28, 2010 2:17 pm

Re: Broken 10.2

Postby neil.anderson » Tue May 29, 2012 5:23 pm

[quote="Michael Newcomb"]I'm having lots of problems with 10.2.0.696 (now upgraded to 10.2.0.777). SQL Compare is showing hundreds of differences between databases that have only minor changes -- if you click the "changed" items no differences show in the compare window.

Further, SQL Compare started popping a window that says it has "magically mapped the following fields." The mapping it shows makes absolutely no sense and seems random, but I can't figure out how to undo it or to stop it from doing anything magically.

Is there any way I can roll back to the old version? I can't use the product in its current state.

Thanks for your help,

Mike N.[/quote]

Hi Mike,

Sorry about the problems you are experiencing. What sort of non-sensical mappings are you seeing? Can you give me the definitions of the tables please?

Are you able to send us snapshots of the databases which are showing invisible differences? If so please send them to support@red-gate.com

I believe the latest update has not been shipped in the installers on the site so if you uninstall Compare and download it again from
http://www.red-gate.com/products/sql-de ... l-compare/ you can revert to the older version 10, just don't update it as yet.

Thanks,
Neil
neil.anderson
 
Posts: 64
Joined: Tue Sep 28, 2010 2:17 pm


Return to SQL Compare 10

Who is online

Users browsing this forum: Bing [Bot] and 0 guests