Just to clarify, the comparison SDK is still shipping with SQL Data Compare v7 components because the product is versioned after the SQL Compare components, which were at version 8 at the time. If you require the latest components, there is an untested beta available (cumulative patch) for you to use.
Anyway, to get the DML triggers disabled in the migration SQL, you may add "DisableTriggers" setting to the SqlOptions you're using. For example:
- Code: Select all
provider.Options = new EngineDataCompareOptions(
ComparisonOptions.TrimTrailingSpaces | ComparisonOptions.Default,
SqlOptions.Default | SqlOptions.DisableTriggers);
Please feel free to let us know if this works for you.