Multiple replications in the same database?

[kslim21]

I have been trying to setup multiple replications on the same database but not successful. This is the scenario:

a) One database has two tables, A & B, for example.

b) Both tables A & B have to be replicated to another server using different pull subscription agents (because of different schedule of update)

How should I setup the publisher & subscribers? Assuming that the diributor is located at the publisher.

Thank you in advance for your help.

KS

 

[JNC73]

You will have to make two publisher jobs for table A & B. And the two different database subscrib on either Publisher for table A or B.

The two publisher jobs have to have different names.

Hope this helps,

JNC73

 

[kslim21]

I have tried to setup what you have suggested. However, the two subscribers, somehow, are pulling data from the same single publisher A even though I have instructed one of them to pull from publisher B.

Thanks for your opinion JNC73. Any other methods that I can try?