set multiple options for a comparison
MarkH
Posts: 8
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.
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
MarkH
Comments
tableMapping.FieldMappings.Options.ComparisonOptions = ComparisonOptions.TrimTrailingSpaces | ComparisonOptions.Default;
For example.
- James
Head of DBA Tools
Red Gate Software Ltd