SQL Compare 10.2 patch released

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 10.2 patch released

Postby Michelle Taylor » Wed Jun 06, 2012 4:56 pm

Download from Check for Updates or here:

http://downloads.red-gate.com/checkforu ... .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.
Michelle Taylor
 
Posts: 529
Joined: Mon Oct 30, 2006 12:45 pm
Location: Red Gate Software

Postby nikolag » Thu Jul 05, 2012 8:21 am

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".
nikolag
 
Posts: 1
Joined: Thu Jul 05, 2012 8:12 am

Re:

Postby kcochran » Mon Jul 09, 2012 5:32 pm

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.
kcochran
 
Posts: 1
Joined: Mon Jul 09, 2012 5:30 pm

Postby dbdmora » Wed Jul 11, 2012 9:40 pm

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?
dbdmora
 
Posts: 34
Joined: Mon Nov 21, 2011 9:55 pm
Location: Atlanta, GA

Postby gclarkjer » Thu Jul 12, 2012 7:46 pm

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.
gclarkjer
 
Posts: 2
Joined: Thu Jul 12, 2012 7:29 pm

Postby ciro.data » Mon Jul 16, 2012 9:00 pm

I am getting the same error when I compare 2000 and 2008 DB. Reinstall didn't help. Does anyone know which previous version work?
ciro.data
 
Posts: 2
Joined: Mon Jul 16, 2012 8:55 pm
Location: US

Postby eddie davis » Tue Jul 17, 2012 9:33 am

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
eddie davis
 
Posts: 942
Joined: Wed Jun 14, 2006 3:47 pm
Location: Red Gate Software

Postby dbdmora » Tue Jul 17, 2012 3:35 pm

Eddie, will this also fix the SSMS integration pack for 2012?
dbdmora
 
Posts: 34
Joined: Mon Nov 21, 2011 9:55 pm
Location: Atlanta, GA

Postby gclarkjer » Tue Jul 17, 2012 4:36 pm

This build appears to fix my problem. Thanks, Eddie! :D
gclarkjer
 
Posts: 2
Joined: Thu Jul 12, 2012 7:29 pm

build 1088 works on SQL 2K DB

Postby ciro.data » Thu Jul 19, 2012 4:48 pm

This patch solves my problem. Thanks.
ciro.data
 
Posts: 2
Joined: Mon Jul 16, 2012 8:55 pm
Location: US


Return to SQL Compare 10

Who is online

Users browsing this forum: Craigjw and 0 guests