October 24, 2007 at 11:11 am
Hey
Thanks for your precious time on the post anyways i have a doubt or you can say question sounds simple may be it is simple or may be its complicated
what i want is from 1 publisher i want the data to be replicated and that data should be filtered so what i figured is for 1 publiser 1 subscriber so for 55 subscriber i have to make 55 publisher but my client dont want this way they want 1 publisher only and that publisher should send the fiiltered data for every sybscriber
for eg subscriber A should get a Firstname , lastname columns from A table and subscriber B should get middlename and DOB coloumns from A table and this should be done by only 1 publisher so i am not sure wether we can do that way or we need to have 55 publisher
Thanks
October 24, 2007 at 3:06 pm
In a publisher, you can have multiple publications, and each publication can have multiple subscriptions on different servers.
For your requirement, if you publish different columns from one table (publisher side) to other tables (subscriber side), you can achieve this by creating different publications.
For example, you have a table_ABCD, with 4 columns col_A, col_B, col_C and col_D. If you want to publish col_A, col_B to a table table_AB, you can create a publication pub_AB that does this. and if you also want to publish col_C, col_D to another table table_CD, you need to create another publication pub_CD to acheieve this.
HTH,
JY
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply