How can we help you today? How can we help you today?

Specified cast is not valid when comparing databases

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
pjimmy
0

Comments

3 comments

  • 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
    0
  • 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
    0
  • 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
    Eddie D
    0

Add comment

Please sign in to leave a comment.