Slow Sync as compared to Red-Gate App

Automate and integrate using the SQL comparison API

Moderator: Chris Auckland

Slow Sync as compared to Red-Gate App

Postby jimmypooh » Wed Nov 17, 2010 2:59 pm

I've been comparing the performance of my app verses the SQL Comparison App. My app seems to be taking 3 times longer and I can't figure out why. Here are my options:

Code: Select all
private EngineDataCompareOptions _options = new EngineDataCompareOptions(MappingOptions.Default ^ MappingOptions.IncludeTimestamps, ComparisonOptions.None,
                                                SqlOptions.DisableKeys | SqlOptions.DisableTriggers | SqlOptions.DropConstraintsAndIndexes | SqlOptions.OutputComments);


and
Code: Select all
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.

Jim
jimmypooh
 
Posts: 8
Joined: Tue Oct 12, 2010 2:17 pm

Return to SQL Comparison SDK Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests