Currently I have data being inserted / updated on sql 2000. I want to update sql 2008 up to the minute. So I need to check and update sql 2008 with insert / update or delete occurred in sql 2000. My question is how to do it?
I do not have timestamp column in any table. So do I need to add timestamp datatype column? If I do, then how do I keep track of starting and end value?
Thanks in advance.
View Complete Post