Thanks Kevin for the suggestions.
Whatz ur thoughts on differential backup everyhour on server A and restore
that into server B.
From ur suggestion.
1) For new record , I can use NOT EXISTS on PK column(s)
2) modified records, look for data change identification
3) deleted records , use again NOT EXITS
Will it not be time consuming joining tables with more records using NOT
EXISTS and step 2 .
Any advantage using differential backup and restore option ??
"Kevin" <only> wrote in message