I am trying to duplicate data from timesten Node2 to a failed node Node1. Before duplicating the data, I want to check if they are already in sync or not. if they are already in sync then I dont need to duplicate the data.
Is there a way to check if the 2 datasources are already in sync? or a count on number of records added/modified on Node2 when Node1 was down; only if count is > 0 then only I want to start data duplication. Pls advise. thanks.
There is no easy way to do this. You could of course unload every table to a flat file using ttBulkCp, sort the files and then diff them. This might be feasibel for a small nunber of tables with not much data but in general it is impractical. It really is best just go ahead and duplicate.