Hi All,
I have a table with a column DeletedDate which stores a logical delete
of a record.
I need to set up transactional replication for reporting purposes that
this deleted records should not be replicated to the subscriber. That
is, if i see a value on the DeletedDate, I don't want that record to
be picked up for replication.
At the same time, when someone marks the record for deletion (by
putting a date on the DeleteDate column), I want that record to be
deleted on the subscriber database. (I can also set up a job to do the
deletes on the subscriber but i'd rather let the replication take care
of it).
Can this scenario be implemented in Microsoft SQL 2000? I would
appreciate any ideas / thoughts in this matter.
Thanks in advance,
Aravin Rajendra.
I have a table with a column DeletedDate which stores a logical delete
of a record.
I need to set up transactional replication for reporting purposes that
this deleted records should not be replicated to the subscriber. That
is, if i see a value on the DeletedDate, I don't want that record to
be picked up for replication.
At the same time, when someone marks the record for deletion (by
putting a date on the DeleteDate column), I want that record to be
deleted on the subscriber database. (I can also set up a job to do the
deletes on the subscriber but i'd rather let the replication take care
of it).
Can this scenario be implemented in Microsoft SQL 2000? I would
appreciate any ideas / thoughts in this matter.
Thanks in advance,
Aravin Rajendra.