Activity overview
Latest activity by pclaar
Thanks for confirming. / comments
Thanks for confirming.
Update: I went to my friend ChatGPT and it appears that SQL Data Compare does not support this scenario, but there is a workaround: https://chatgpt.com/share/674fabd3-b770-8007-9682-cc00a5bc21e4 If I set the WHERE clause in the source database only, I get the result I want... [image] ...if I uncheck the 81819 records. But this is hugely inefficient since I have to read each and every row from the target database. / comments
Update: I went to my friend ChatGPT and it appears that SQL Data Compare does not support this scenario, but there is a workaround: https://chatgpt.com/share/674fabd3-b770-8007-9682-cc00a5bc21e4If ...
Force newly updated rows from a source to a target database?
I've been using SQL Data Compare for years but I can't figure out a way to do this simple task...I'm updating rows in my source database and it has a column called "DateUpdated". This field will ge...