Specified cast is not valid when comparing databases

pjimmypjimmy Posts: 2
edited July 11, 2012 2:50PM in SQL Compare Previous Versions
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
· Share on Twitter

Comments

Sign In or Register to comment.