set multiple options for a comparison

MarkHMarkH Posts: 8
edited November 27, 2006 4:56AM in SQL Toolkit Previous Versions
Hi,

Would somebody please show me how to set multiple options for a comparison using the Sql Toolkit,

i.e. I want to ignore space, trim trailing, ignnore case and use checksum comparions,

I have found my way to ...

tableMapping.FieldMappings.Options.ComparisonOptions = ComparisonOptions.TrimTrailingSpaces;

but im struggling to get any furthur,

Mark.
Regards,

MarkH

Comments

  • Comparison options is a flag enum so you can do this by:

    tableMapping.FieldMappings.Options.ComparisonOptions = ComparisonOptions.TrimTrailingSpaces | ComparisonOptions.Default;

    For example.

    - James
    James Moore
    Head of DBA Tools
    Red Gate Software Ltd
Sign In or Register to comment.