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

Error in precision when using SQL Data Compare 12.3

I'm getting the following error when comparing a database to our source control version of the same database.
"Invalid numeric precision/scale" appears when I use the GUI or command line version of the SQL Data Compare.
What could cause this and how do I get around it?
7w9jacm45c4u.jpg

Mike Malinowski
0

Comments

1 comment

Sort by
  • Jessica R
    Hi mikemalino,

    This might be a problem with the SQL Source Control cache, can you please try the following steps:
    1 - Unlink the DB from Source Control
    2 - Delete the contents of all subfolders inside %localappdata%\Red Gate\SQL Source Control 5\Caches
    (Please note that %localappdata% is a Windows Environment variable that usually corresponds to C:\Users\{username}\AppData\Local )
    3 - Relink DB
    4 - Try comparing it again
    Jessica R
    0

Add comment

Please sign in to leave a comment.