sql server replication: Merge Replication and Deletes -- sql server replication

Merge Replication and Deletes

Kevin Thomas
12/7/2004 2:27:32 PM

sql server replication:

Hi there,

I have four databases set up with merge replication. I have a filter that
says only replicate a record if its timestamp is greater than one day ago (I
don't care about any data older than one day).

If I now go into Database #1 and delete a record that is older than one day,
I do not expect to see this record deleted from the other databases (in
other words, I expect that it would remain in the others). However, all the
deletes for records older than one day ARE being replicated to the other
databases. I'd really prefer that this didn't happen.

Does anyone know why this occurs?

Thanks,

Kevin

RE: Merge Replication and Deletes

Robert Davis
12/8/2004 1:27:05 AM

Because you told it to. You said that your filter says to only replicate if
the timestamp is greater than one day ago, and it's timestamp is greater than
1 day ago.

If you want it to not be replicated, then update the timestamp to the
current date first and then delete.

Robert.

[quoted text, click to view]

Re: Merge Replication and Deletes

Kevin Thomas
12/8/2004 9:23:54 AM

Perhaps I misspoke, I apologize. I only want to replicate data that is less
than a day old. I want to delete data that is greater than a day old. When
I delete the data that is older than one day, those deletes are replicated,
even though I don't expect that they would because of the filter.

Thanks for your help,

Kevin

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server replication group.