Data comparison in replication

Posted by Nishithraj under Sql Server on 2/25/2010 | Views : 914 | Status : [Member] | Replies : 2
Whether there is a way to do data comparison before the replication? If it is there, which replication provides the same?

Mark this as answer, if it is.....

With regards
Nishithraj Narayanan



Responses

Posted by: Abhi2434 on: 2/25/2010 [Member] [Microsoft_MVP] [MVP] Silver

Up
0
Down
I dont find the meaning of your question... Do you want to do a data comparison before replication... ?
Replication and Data Comparison is totally different part. You can invoke each of them individually.

IF you are looking for a tool, here is one
http://www.red-gate.com/products/sql_data_compare/technical_papers/replication_made_simple.htm

www.abhisheksur.com

Nishithraj, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Nishithraj on: 2/26/2010 [Member] Bronze

Up
0
Down
That I know.

My requirement is different. like a database needs to be replicated every time. Before replication the data needs to be updated if it is already existing in the replication database. Otherwise, it needs to be inserted.

Mark this as answer, if it is.....

With regards
Nishithraj Narayanan

Nishithraj, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response