SQL Compare 10.2.0.916 and SQL Server 2000

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.0.916 and SQL Server 2000

Postby jmeyer » Thu Jun 07, 2012 10:43 pm

When SQL Compare starts to register the data sources of a SQL Server 2000 database it aborts with an error message of "Specified cast is not valid" when reading table columns.

Using SQL Compare 9.5.0.282 the same comparison against the same database servers and databases is successful, however.

This seems to happen on pretty much all databases, even onces that had not changed in months.
jmeyer
 
Posts: 20
Joined: Fri Jun 05, 2009 3:07 pm

Postby peter.peart » Mon Jun 11, 2012 8:26 pm

Thanks for your post. We've got this logged as an issue in our bug tracking system under reference number SC-5801.

I don't honestly know if this will be fixed since support for SQL Server 2000 has been deprecated, however I will keep you updated with any news of a fix.

Pete
Last edited by peter.peart on Thu Jun 28, 2012 8:06 pm, edited 1 time in total.
Peter Peart
Red Gate Software Ltd
+44 (0)870 160 0037 ext. 8569
1 866 RED GATE ext. 8569
peter.peart
Site Admin
 
Posts: 362
Joined: Tue Sep 02, 2008 9:58 am
Location: Top floor, RG towers with the cool kids

Postby peter.peart » Thu Jun 21, 2012 4:21 pm

Thanks for your patience. We have now fixed this, and it should be available in a release of the tool which will be coming in the next couple of weeks.

Pete
Peter Peart
Red Gate Software Ltd
+44 (0)870 160 0037 ext. 8569
1 866 RED GATE ext. 8569
peter.peart
Site Admin
 
Posts: 362
Joined: Tue Sep 02, 2008 9:58 am
Location: Top floor, RG towers with the cool kids

This is a CRITICAL issue!

Postby MuddyDave » Fri Jun 22, 2012 1:58 am

I bought the SQL Developer Bundle last week. Support for SQL 2000 was working fine before and was critical in my decision to purchase the product. SQL Compare is now useless to me without support for SQL 2000. Waiting a couple of weeks for fix seems unreasonable. Does RedGate not offer hot fixes for bugs they introduce? Can I uninstall the product and install a previous version?
MuddyDave
 
Posts: 1
Joined: Fri Jun 22, 2012 1:49 am

Postby echamber623k » Mon Jun 25, 2012 9:40 pm

I am running version 10.0.0.160 without any problems but do see problems with latest. Could you post this older version for download? I only saw through 9.5 of SQL compare as available from older versions download.
echamber623k
 
Posts: 1
Joined: Mon Mar 05, 2012 7:59 pm
Location: United States

Specified Cast is not valid

Postby CarlaAbanes » Thu Jun 28, 2012 4:33 am

Can you post when the release of the updated version with the bug fix will be? I need to justify a purchase of this to my boss and we are supporting sql 2000 production data.
CarlaAbanes
 
Posts: 1
Joined: Thu Jun 28, 2012 4:30 am

Postby peter.peart » Thu Jun 28, 2012 8:08 pm

Sorry, I didn't realise there were replies to this as the e-mail notification didn't work :/

Anyway, you can get V10.1.065 from the below link:

ftp://support.red-gate.com/patches/SQLC ... 1.0.65.zip

HTH!

Pete
Peter Peart
Red Gate Software Ltd
+44 (0)870 160 0037 ext. 8569
1 866 RED GATE ext. 8569
peter.peart
Site Admin
 
Posts: 362
Joined: Tue Sep 02, 2008 9:58 am
Location: Top floor, RG towers with the cool kids

Postby jmeyer » Thu Jul 26, 2012 8:19 pm

SQL Compare 10.2.0.1108 seems to have fixed the issues.
jmeyer
 
Posts: 20
Joined: Fri Jun 05, 2009 3:07 pm

Postby dlee20 » Tue Dec 11, 2012 7:36 pm

not fixed in 10.2.0.77, it is now 12/11/2012... is there a fix yet?
dlee20
 
Posts: 1
Joined: Tue Dec 11, 2012 7:34 pm

Postby Brian Donahue » Wed Dec 12, 2012 1:17 pm

Just to reiterate, "Specified Cast is not valid" is a generic exception and therefore will never be eradicated. First, yes, it could be a programming mistake. But more commonly, it's inconsistency in the metadata describing the database schema.

I'd recommend emailing support at red-gate.com and open a support case.
Brian Donahue
 
Posts: 6669
Joined: Mon Aug 23, 2004 10:48 am


Return to SQL Compare 10

Who is online

Users browsing this forum: No registered users and 1 guest