Unsupported column type - Empty

Compares and synchronizes SQL database content.

Moderators: JonathanWatts, Chris Auckland, David Atkinson, Michelle Taylor, chengvoon.tong

Unsupported column type - Empty

Postby Meriguan » Thu Apr 25, 2013 3:30 pm

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?
Meriguan
 
Posts: 6
Joined: Wed Dec 12, 2012 3:09 pm

Postby Manfred.Castro » Thu Apr 25, 2013 7:32 pm

The /ComparisonKeys switch(/ComparisonKeys:<table or view name as regular expression>:<index name>) allows you to specify a unique index to be used to identify rows for comparison. With /ComparisonKeys you can only specify an index as the comparison key, no other columns can be specified.

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
Manfred Castro
Product Support
Red Gate Software
Manfred.Castro
 
Posts: 209
Joined: Mon Apr 23, 2012 2:49 pm

Postby JureP » Fri Jul 19, 2013 5:24 pm

I'm getting the same error when using the switch /include:StaticData with SQL compare.

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
JureP
 
Posts: 3
Joined: Fri Jul 19, 2013 4:45 pm


Return to SQL Data Compare 10

Who is online

Users browsing this forum: No registered users and 0 guests