Activity overview
Latest activity by ColorearM
You can do this with SQL Data Compare — the key is to keep it simple. Set the WHERE clause only on the source, like: DateUpdated >= '2024-12-03' Keep all columns in the comparison (otherwise SQL Data Compare won’t generate updates). Then it works like this:
If the key exists in target → it updates the row
If the key doesn’t exist → it inserts the row
Rows not updated today simply aren’t compared
It’s basically like ColoreaM: you “re-color” only the areas that changed, but you still need the full set of details to apply the update. / comments
You can do this with SQL Data Compare — the key is to keep it simple.Set the WHERE clause only on the source, like:DateUpdated >= '2024-12-03' Keep all columns in the comparison (otherwise SQL Data...