syncronize records

[jagdeep]

I wanna syncronize data from two sources. (say fields like First Name, Last Name, Email, TimeStamp)
I wanna syncronize their changes during last 24 hours. I check the TimeStamp for the whole record. i dont care about fields.
Whechever is the latest Updates/Creates it on other side depending upon if it exists there.
The side having greater TimeStamp rules and the record is overwritten on the loosing side. Great..
The catch is if the record does not exist at other side... i wanna create a new record.
I jes wanna read the records that have changed during last 24 hours at either side in two separate DataSets. I will batch update them Later.
since a record was not modified/ or it did not exist it was not selected...
How im gonna know (if i read only the records that have changed during last 24 hours)
if i need to (add/ or modify) it to other side?
Rephrase: if it already exists or not on other side?


Regards - Singh

http://Jagdeep.8m.net

 

[mrdenny]

I'm not really sure what you are asking for here? Can you be a little more clear with what you are asking for?

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com