| Author |
Message |
stefan.r
Joined: 13 Jul 2012 Posts: 1
|
Posted: Fri Jul 13, 2012 2:49 pm Post subject: Error: Invalid numeric precision/scale on data compare |
|
|
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 |
|
 |
|
|
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