Replication btw 2 tables in same database.

[Pratik Singh]

Hello Guys ,

I have one odd kind of requirement. I need to copy some kind of data from table1 to table2 , I was using trigger earlier but that kills the DB.

is that possible if I can use replication btw 2 tables in same database. like what event insert/update/delete happened on table1 , that should replicate on table2 .. if that is possible then no need to use big trigger finally to copy the data from one table to other table...

in other tear I would say table1 is subset of table2 .. so what ever happen in table1 , should replicate on table2

would be great ,if there is other solution is possible to copy the data from table1 to table2 at the end process ( except trigger)

Please do let me know if my requirement is not enough clear ...

Thanks in advance !