Unsupported column type - Empty
Meriguan
Posts: 11
Hi All,
SQL Data Copmare 8.1.0.4
I try to compare scripts folders and get error "Unsupported column type- Empty". It means table contains PK with User-Defined Data Type column. This datatype was commited in folder "Types", but SQL Data Compare doesn't use it for comparing as I understood.
I changed "Comparison key" to "Custom" and set the same columns like has PK and comparing works fine.
The question is Can I set Custom Comparison key in the command line for each tables? What command I should use?
SQL Data Copmare 8.1.0.4
I try to compare scripts folders and get error "Unsupported column type- Empty". It means table contains PK with User-Defined Data Type column. This datatype was commited in folder "Types", but SQL Data Compare doesn't use it for comparing as I understood.
I changed "Comparison key" to "Custom" and set the same columns like has PK and comparing works fine.
The question is Can I set Custom Comparison key in the command line for each tables? What command I should use?
Comments
To specify a comparison key that is is not an index, use the GUI to set up and save a project with the settings you require. You can then use that project from the command line with the /Project switch.
https://documentation.red-gate.com/disp ... mmand+line
Product Support
Red Gate Software
Is there a workaround you might suggest until you fix this bug? I think I need to use something like /dataCompareProject:myCustomComparisons.sdc
Thanks, best regards
Jure