| Author |
Message |
Michelle Taylor
Joined: 30 Oct 2006
Posts: 522
Location: Red Gate Software
|
 Posted: Wed Jun 06, 2012 4:56 pm Post subject: SQL Compare 10.2 patch released |
 |
|
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 |
|
 |
nikolag
Joined: 05 Jul 2012
Posts: 1
|
| Posted: Thu Jul 05, 2012 8:21 am Post subject: |
|
|
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 |
|
|
kcochran
Joined: 09 Jul 2012
Posts: 1
|
| Posted: Mon Jul 09, 2012 5:32 pm Post subject: Re: |
|
|
| 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 |
|
|
dbdmora
Joined: 21 Nov 2011
Posts: 32
Location: Atlanta, GA
|
| Posted: Wed Jul 11, 2012 9:40 pm Post subject: |
|
|
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 |
|
|
gclarkjer
Joined: 12 Jul 2012
Posts: 2
|
| Posted: Thu Jul 12, 2012 7:46 pm Post subject: |
|
|
| 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 |
|
|
ciro.data
Joined: 16 Jul 2012
Posts: 2
Location: US
|
| Posted: Mon Jul 16, 2012 9:00 pm Post subject: |
|
|
| 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 |
|
|
eddie davis
Joined: 14 Jun 2006
Posts: 804
Location: Red Gate Software
|
| Posted: Tue Jul 17, 2012 9:33 am Post subject: |
|
|
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 |
|
|
dbdmora
Joined: 21 Nov 2011
Posts: 32
Location: Atlanta, GA
|
| Posted: Tue Jul 17, 2012 3:35 pm Post subject: |
|
|
| Eddie, will this also fix the SSMS integration pack for 2012? |
|
| Back to top |
|
|
gclarkjer
Joined: 12 Jul 2012
Posts: 2
|
| Posted: Tue Jul 17, 2012 4:36 pm Post subject: |
|
|
This build appears to fix my problem. Thanks, Eddie!  |
|
| Back to top |
|
|
ciro.data
Joined: 16 Jul 2012
Posts: 2
Location: US
|
| Posted: Thu Jul 19, 2012 4:48 pm Post subject: build 1088 works on SQL 2K DB |
|
|
| This patch solves my problem. Thanks. |
|
| Back to top |
|
|
|
