In order to speed the transfer up, there's no need to compare every single record in the db, I only need to review records whose DMDate (Data Modified) column has been updated within the last month.
I cannot seem to create a suitable where clause for the destination database; if I use the same clause for both, then some records from the first are not found in the second, and then they are treated as new records, and then I get a primary key violation.
If I use an EMPTY clause for the second database, then the performance gain is lost.
My code currently looks like this:
- Code: Select all
mapping.Where = New WhereClause("LastEdit >= '" & varFilterDate & "'", "")
I feel like it should be checking for the existence of a record before attempting to either do an INSERT or an UPDATE, so that it is always right.
What am I missing?
Thanks in advance!