Red Gate forums :: View topic - Issues with new Release 10.2.0.696
Return to www.red-gate.com RSS Feed Available

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

Issues with new Release 10.2.0.696

Search in SQL Compare 10 forum
Post new topic   Reply to topic
Jump to:  
Author Message
skuhn



Joined: 30 Dec 2011
Posts: 19

PostPosted: Wed May 23, 2012 3:09 pm    Post subject: Issues with new Release 10.2.0.696 Reply with quote

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.)
Back to top
View user's profile Send private message
neil.anderson



Joined: 28 Sep 2010
Posts: 64

PostPosted: Wed May 23, 2012 3:21 pm    Post subject: Reply with quote

Hi Skuhn,

Can you try the patch build from here:

ftp://support.red-gate.com/patches/sql_compare/sql_compare_10.2.0.777.zip

and let me know if it fixes your problem?

Thanks,
Neil
Back to top
View user's profile Send private message
skuhn



Joined: 30 Dec 2011
Posts: 19

PostPosted: Wed May 23, 2012 3:37 pm    Post subject: SQL Compare Patch Reply with quote

Hi Neil,

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

Scott Kuhn
Back to top
View user's profile Send private message
DLDM



Joined: 24 May 2012
Posts: 1

PostPosted: Thu May 24, 2012 8:02 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message
Michael Newcomb



Joined: 19 Mar 2008
Posts: 2

PostPosted: Tue May 29, 2012 3:22 pm    Post subject: Broken 10.2 Reply with quote

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.
Back to top
View user's profile Send private message
neil.anderson



Joined: 28 Sep 2010
Posts: 64

PostPosted: Tue May 29, 2012 5:18 pm    Post subject: Re: Reply with quote

[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
Back to top
View user's profile Send private message
neil.anderson



Joined: 28 Sep 2010
Posts: 64

PostPosted: Tue May 29, 2012 5:23 pm    Post subject: Re: Broken 10.2 Reply with quote

[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-development/sql-compare/ you can revert to the older version 10, just don't update it as yet.

Thanks,
Neil
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