'Specified cast is not valid.'

notec

When doing a Compare between a SQL2K 32-bit and SQL2K5 64-bit the compare aborts with 'Specified cast is not valid.'

Any thoughts?

Simon L

Hello,

Our apologies for not getting back to you sooner...

Normally this issue is caused by the login you are using for the comparison not having sufficient permissions in the database(s), as explained here:

http://www.red-gate.com/messageboard/vi ... php?t=3999

It's a somewhat obscure error, so doesn't really give much of a hint as to what it might be.

Do you think you would be able to try it with a user which has dbo rights and see if that works?

Paul Casimir

Thanks for making these forums available. I searched for my error here, and permissions was my problem for my version 5.3 Data Compare.

Somehow the view permissions got dropped for our developer group on the database in question, and once our DBA set them correctly again, the Compare worked fine.