Different Table Names with Transactional Replication
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
DB A, Table A
DB B, Table A
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,