Conversion failed when converting from a character string to uniqueidentifier

JessB

I'm new to RedGate Compare, but I need to compare a database on my localhost with a database on my production server.  We had a software upgrade and the structure has changed on about 500 tables.  Several of the changes have to deal with converting a character string to a unique identifier, and I'm getting the error:  "Conversion failed when converting from a character string to a uniqueidentifier" when I try to deploy.  Has anyone see this?  Am I missing an option?  Thank you!

Jessica R

Hi @JessB!

I suspect that some of the character strings may not be in the right format to be successfully converted to uniqueidentifier as described here: https://www.sqlservercentral.com/forums/topic/conversion-failed-when-converting-from-a-character-string-to-uniqueidentifier

Can you please check if this is the case?

olinreynolds

The animatronics in FNAF have distinctive designs and personalities.