question

ZahidNadeem-8256 avatar image
0 Votes"
ZahidNadeem-8256 asked Criszhan-msft commented

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

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

sql-server-general
5 |1600 characters needed characters left characters exceeded
Toggle Comment visibility. Current Visibility: Visible to all users

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

Criszhan-msft avatar image
0 Votes"
Criszhan-msft answered Criszhan-msft commented

Hi @ZahidNadeem-8256,

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.

· 4
5 |1600 characters needed characters left characters exceeded
Toggle Comment visibility. Current Visibility: Visible to all users

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

ZahidNadeem-8256 avatar image ZahidNadeem-8256 ·

Thanks for your time.
Now if I create new publication with selected tables & columns, do I have to create new distributor as well (or already created distribution can be used) ?

Thanks once again.

0 Votes 0 ·
Criszhan-msft avatar image Criszhan-msft ZahidNadeem-8256 ·

Hi @ZahidNadeem-8256,

You just need to use the already configured distribution.

0 Votes 0 ·
ZahidNadeem-8256 avatar image ZahidNadeem-8256 Criszhan-msft ·

Thanks a lot.

0 Votes 0 ·
Show more comments