Red Gate forums :: View topic - Error: Invalid numeric precision/scale on data compare
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Data Compare 10
SQL Data Compare 10 forum

Error: Invalid numeric precision/scale on data compare

Search in SQL Data Compare 10 forum
Post new topic   Reply to topic
Jump to:  
Author Message
stefan.r



Joined: 13 Jul 2012
Posts: 1

PostPosted: Fri Jul 13, 2012 2:49 pm    Post subject: Error: Invalid numeric precision/scale on data compare Reply with quote

I'm using the following command to sync a database to a scripts folder :
- sqldatacompare.exe /s1:Computer /db1:DB /makescripts:"c:\Scripts" /verbose /sync
This works fine.But when I try a compare of the DB database to the scripts generated previously I get the following error : invalid numeric precision/scale
This is the compare command:
- sqldatacompare.exe /s1:Computer /db1:DB /scripts2:"c:\Scripts" /verbose
I've also tried from the GUI to create a project but the same error appears.Please note that this is run on a controlled environment and no changes are made to the DB database.Also when comparing the scripts with the database (switch the source and destination) I get no errors and it works as expected(no differences). Also please note that most of the tables that give the error (I didn't check them all) have columns that are defined as custom types.
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group