Selecting Specific tables & columns for new subscriber in existing Transaction Replication Publication

Question

Hi,

We have Transaction replication in place working fine with 3 publications on server A , Subscriptions on 2 different servers B & C.

Now we want to add another subscription on server D to same publications but we want selected tables & selected columns from existing publications to new subscriber(D). Is it possible ?

If yes, will it not impact distribution database as it is same for all the subscribers.

Thanks

Answer 1

Hi @Zahid Butt ,

>Now we want to add another subscription on server D to same publications but we want selected tables & selected columns from existing publications to new subscriber(D). Is it possible ?

No, it's not possible in transactional replication. You need to modify an existing publication or create a new one to contain only specific tables and columns.