Red Gate forums :: View topic - SQL Compare 10.2 patch released
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

SQL Compare 10.2 patch released

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



Joined: 30 Oct 2006
Posts: 525
Location: Red Gate Software

PostPosted: Wed Jun 06, 2012 4:56 pm    Post subject: SQL Compare 10.2 patch released Reply with quote

Download from Check for Updates or here:

http://downloads.red-gate.com/checkforupdates/SQLCompare/SQLCompare_10.2.0.916.exe

Some customers have been experiencing problems with SQL Server 2000 databases and the new SSMS integration, particularly with SQL Server 2012.

This new patch release should fix those problems, along with several more bug fixes:

SC-5581: Command line now automatically uses filter file from scripts folder if one is present
SC-5677: /assertidentical now works with /report on the command line
SC-5332: Stored procedures referencing tables with a database name will now have better dependency ordering behaviour
SC-5447: Schema-bound views now no longer try to drop auto-dropped extended properties on indexes
SC-5647: Identity insert on table rebuild now works correctly with ignore identity option
SC-5767: Command line can now make snasphots from source control data sources

SC-5589/SC-4867/SC-5750: Images in reports should now more reliably use online images if local source unavailable
SC-5665: Keyboard include/exclude all shortcut now correctly updates selected object count
SC-5084: Saving a database to a folder via the file menu now works the same as deploy to empty folder
SC-5595: /makescripts command line option now works the same as deploy to empty folder
SC-5126: Ignore permissions option now does not add permissions anyway when creating script folder
SC-5267: Migration script viewer temp file support should be more stable
SC-5408: Rare UI timing glitch should no longer fail to dispose dialog correctly
SC-5520: Prevent UI throwing an exception in rare program closing race condition
SC-5678: Better error message when /scriptsfolderxml points to invalid file


Last edited by Michelle Taylor on Wed Nov 07, 2012 6:37 pm; edited 1 time in total
Back to top
View user's profile Send private message
nikolag



Joined: 05 Jul 2012
Posts: 1

PostPosted: Thu Jul 05, 2012 8:21 am    Post subject: Reply with quote

I installed the new patch, but the problem, comparing two SQL2000 database, remains.
The message error is "Specified cast is not valid." and appears during the phase "Registering data sources".
Back to top
View user's profile Send private message
kcochran



Joined: 09 Jul 2012
Posts: 1

PostPosted: Mon Jul 09, 2012 5:32 pm    Post subject: Re: Reply with quote

nikolag wrote:
I installed the new patch, but the problem, comparing two SQL2000 database, remains.
The message error is "Specified cast is not valid." and appears during the phase "Registering data sources".


This is happening to me as well. I am trying to compare SQL Server 2005 databases, however.

What would be tremendously helpful is if there were some kind of log where I could see what object it is choking on.
Back to top
View user's profile Send private message
dbdmora



Joined: 21 Nov 2011
Posts: 32
Location: Atlanta, GA

PostPosted: Wed Jul 11, 2012 9:40 pm    Post subject: Reply with quote

I re-installed SQL compare 10 with above patch and both my SSMS 2008 & 2012 when trying to open SQL compare from SSC history, it says "it cannot update to the selected version because SSMS Integration pack is not installed.

How can I get this to work?
Back to top
View user's profile Send private message
gclarkjer



Joined: 12 Jul 2012
Posts: 2

PostPosted: Thu Jul 12, 2012 7:46 pm    Post subject: Reply with quote

I also am getting this error with this version. I've submitted several reports but have not recieved any response. I'm comparing a SQL 2000 db against a SQL 2008 db. This was working fine in my previous version (not sure what that version was). I'm using the Red Gate Defaults for the compare. Not sure where to go from here.
Back to top
View user's profile Send private message
ciro.data



Joined: 16 Jul 2012
Posts: 2
Location: US

PostPosted: Mon Jul 16, 2012 9:00 pm    Post subject: Reply with quote

I am getting the same error when I compare 2000 and 2008 DB. Reinstall didn't help. Does anyone know which previous version work?
Back to top
View user's profile Send private message
eddie davis



Joined: 14 Jun 2006
Posts: 889
Location: Red Gate Software

PostPosted: Tue Jul 17, 2012 9:33 am    Post subject: Reply with quote

Hi ciro.data, gclarkjer and dbdmora,

Please try this PATCH for SQL Compare V10.2.0.1108.

The patch fixes an issue where SQL Compare errors with the "Specified cast is not valid." error message when attempting to compare SQL 2000 databases.

Many Thanks
Eddie
_________________
Eddie Davis
Technical Support Engineer
Red Gate Software Ltd
E-mail: support@red-gate.com
Back to top
View user's profile Send private message Send e-mail
dbdmora



Joined: 21 Nov 2011
Posts: 32
Location: Atlanta, GA

PostPosted: Tue Jul 17, 2012 3:35 pm    Post subject: Reply with quote

Eddie, will this also fix the SSMS integration pack for 2012?
Back to top
View user's profile Send private message
gclarkjer



Joined: 12 Jul 2012
Posts: 2

PostPosted: Tue Jul 17, 2012 4:36 pm    Post subject: Reply with quote

This build appears to fix my problem. Thanks, Eddie! Very Happy
Back to top
View user's profile Send private message
ciro.data



Joined: 16 Jul 2012
Posts: 2
Location: US

PostPosted: Thu Jul 19, 2012 4:48 pm    Post subject: build 1088 works on SQL 2K DB Reply with quote

This patch solves my problem. Thanks.
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