Specified cast is not valid when comparing databases

pjimmy

I am getting a fairly nondescript error messages when comparing 2 databases "Specified cast is not valid"

Here is an extract from my log files

16:34:00.744|Trace |Source Control Link |7 |SQL Source control link successfully created
16:34:00.744|Trace |Source Control Link |6 |SQL Source control link successfully created
16:34:00.784|Error |SQL Compare UI |1 |Exception in progress dialog
System.InvalidCastException: Specified cast is not valid.
at System.Data.SqlClient.SqlBuffer.get_SqlDecimal()
at System.Data.SqlClient.SqlDataReader.GetSqlDecimal(Int32 i)
at #8rg.#Ysg.#unh(Int32 #G8)
at #8rg.#Ssg.#Vlh()
at #8rg.#Ssg.#vl(DBPopulationOptions #WXrc)
at RedGate.SQLCompare.Engine.Database.#crc(ConnectionProperties #Ap8b, Options #5OPb)
at RedGate.SQLCompare.Common.CompareEngineExecutor.#DaH(Database #RHc, LiveDatabaseSource #ovUb)
at RedGate.SQLCompare.Common.CompareEngineExecutor.#DaH(Database #RHc, DataSource #ovUb)
at RedGate.SQLCompare.Common.CompareEngineExecutor.#7bH()
at #dRb.#8Rb.#kco()
at RedGate.Shared.Controls.ProgressDialogEx.#Pao()
16:34:00.946|Trace |Source Control Link |16 |SQL Source control link successfully created
16:34:00.946|Trace |Source Control Link |10 |SQL Source control link successfully created

Eddie D

Thank you for your post into the forum and sorry that you have encountered a problem.

A support call has been created for you, the call reference number is F0061985. I will provide an update when I have further information to pass.

Many Thanks
Eddie Davis

Eddie D

I have send you a private message via this forum. Please read and try out the recommendation in the message.

Many Thanks
Eddie

Eddie D

Quick update in case any other users encounter this problem.

A SQL Compare V10 patch fixes this issue which be downloaded using this LINK.

Otherwise please contact Red Gate using this e-mail address, support@red-gate.com

Many Thanks
Eddie