We are using SQL Server 2008. We have two databases that may be on the same
machine or different machines. Both have duplicate table names with
non-duplicate schemas:

DB A, Table A

X Integer
Y Bit
Z Varchar(20)

DB B, Table A

M Integer
N-Q Float
Y Bit
Z Varchar(20)


I need to replicate PART of DB A, Table A to DB B, Table A. What I did was
create a A.B_A on database A, with database B's table A schema. I have a
trigger that modifies B_A when A.A gets modified.


Is there a way I can replicate B_A to database B, table A? I know I could
replicate B_A to database B, then trigger, AGAIN, to B.A, but I'd like to
skip the step if possible.

Thanks in advance,

Terry