Specified cast is not valid when comparing databases

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

Specified cast is not valid when comparing databases

Postby pjimmy » Mon Jul 02, 2012 7:51 am

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
 
Posts: 1
Joined: Mon Jul 02, 2012 7:49 am

Postby eddie davis » Wed Jul 04, 2012 3:20 pm

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 Davis
Technical Support Engineer
Red Gate Software Ltd
E-mail: support@red-gate.com
eddie davis
 
Posts: 943
Joined: Wed Jun 14, 2006 3:47 pm
Location: Red Gate Software

Postby eddie davis » Wed Jul 04, 2012 3:28 pm

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

Many Thanks
Eddie
Eddie Davis
Technical Support Engineer
Red Gate Software Ltd
E-mail: support@red-gate.com
eddie davis
 
Posts: 943
Joined: Wed Jun 14, 2006 3:47 pm
Location: Red Gate Software

Postby eddie davis » Wed Jul 11, 2012 7:50 pm

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 Davis
Technical Support Engineer
Red Gate Software Ltd
E-mail: support@red-gate.com
eddie davis
 
Posts: 943
Joined: Wed Jun 14, 2006 3:47 pm
Location: Red Gate Software


Return to SQL Compare 10

Who is online

Users browsing this forum: No registered users and 1 guest