October 31, 2002 at 2:26 am
i have a table A1 in a database DB and am replicating that table to table A2 in same database in another server.i want to replicate table A1 to one more table A3 in which i want only records which are changed (updated ur inserted)daily .if there is no change in the record of A1 i dont want that record to come in A3.here A1,A2,A3 have same table structure.is it possible through replication.
can anybody tell me?
October 31, 2002 at 4:09 am
You cannot send only the items that changed to A3 thru replication and not the othrs. Your best bet is to use a TRIGGER and build a staging table to have DTS move it, try trigger to insert into A3, or if you put a column on the table you can update when a row is changed so that later DTS ca move to A3 and reset the rows marker.
November 5, 2002 at 10:30 am
In transactional replication, only changed (INSERT/UPDATE/DELETE) records are replicated to the subcriber database. Are you also trying to track deleted rows? If so, you must create a trigger that inserts into a tracking/log table from the "DELETED" pseudo-table in the trigger, otherwise that row is gone forever.
-Dan
-Dan
November 5, 2002 at 7:22 pm
quote:
In transactional replication, only changed (INSERT/UPDATE/DELETE) records are replicated to the subcriber database. Are you also trying to track deleted rows? If so, you must create a trigger that inserts into a tracking/log table from the "DELETED" pseudo-table in the trigger, otherwise that row is gone forever.-Dan
Transactional replication will snapshot all the data over, I was thinking rejesha only wanted to move the changed data without copying over the entire data.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply