Error: Invalid numeric precision/scale on data compare
stefan.r
Posts: 2 New member
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.
- 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.
