peterlaursen wrote on Jun 16 2007, 03:04 AM:
create a batch file that exectues
– a SJA sync job
– a SJA notifications job that does the UPDATE
and you can execute and/or schedule the .bat file
Perfect – I knew the program could do this, I just didn't know where to look. It works just as I need it to, thank you.
I wasn't certain if your answer was also an answer to my 'can you filter out certain columns from the updating process,' so let me describe what I meant with a little more clarity. It would be a great feature if it wasn't one.
Lets say I have a table with 3 columns: A – B – C. They each have several rows of data. And lets say the data in column B I want to be left unchanged.
Currently – If I have the sync look at column A and C, and it finds a checksum difference – It replaces the whole ROW. This means the data in column B is overwriten.
What I would like to have happen – Have the sync look at column A and C in each row, and if it finds a checksum difference, it only replaces the data in Column A and C, and not changing the data in column B.
