We want to use RedGate's SQL Data Compare to migrate user data from one DB to a DB on a completely different provider. This will be a time-sensitive operation as we do not want our site offline for too long and there will be a lot of data that needs to be moved. We do not want any I/O on the table during this time.
Has anyone using RedGate found that adding additional indexes on some of our comparison criteria columns (i.e. DateCreated, DateModified) will affect the time to perform this? Our initial testing is at about 25-30 min for comparison of the source -> target DBs at the moment.