Slow Sync as compared to Red-Gate App
private EngineDataCompareOptions _options = new EngineDataCompareOptions(MappingOptions.Default ^ MappingOptions.IncludeTimestamps, ComparisonOptions.None, SqlOptions.DisableKeys | SqlOptions.DisableTriggers | SqlOptions.DropConstraintsAndIndexes | SqlOptions.OutputComments);
sessionSettings = sessionSettings ^ SessionSettings.IncludeIdenticalRecords;
Are there any other settings I can use to speed things up? Thanks! I was also hoping there was a way to speed things up by comparing outside of the same session so I can show user the compare results then they can sync without it having to compare again before sync.