Replication probelm

Dear All,
I am currently reading the chapter of replication of MS SQL Server 2000
online book.
I just startup to read it.
I have some misunderstanding.
What is the different between Publisher and Distributor?
If I have a application, which database I should connected to? Publisher onr
or distributor one?
Or no matter how which I connected to?
Thanks~
Here's my idea
Application is connected to Publisher, and Publisher will make a copy of
data (publication) to Distributor.
And Distributor will use that data to copy to other Subscriber, or
Subscriber requests data from Distributor.
Am I right?
Thanks
|||If the application makes the changes that you want to replicate then you are
correct in connecting to the publisher. The Publisher and the distributor can
be on the same machine. How you described it in your second post is how it
works. As an example the replication setup that was used at my last company
was, one top level publisher under this there where 5 distributors that then
relayed any updates out to the subscribers.
"Utada P.W. SIU" wrote:

> Here's my idea
> Application is connected to Publisher, and Publisher will make a copy of
> data (publication) to Distributor.
> And Distributor will use that data to copy to other Subscriber, or
> Subscriber requests data from Distributor.
> Am I right?
> Thanks
>
>
|||Utada,
this arrangement, where data 'flows' through the distributor, is true of
'vanilla' snapshot and transactional replication. In each case it is
slightly different: in transactional replication, data modifications are
posted into the MSrepl_commands table in the distribution database, and in
snapshot replication, it is the location/names of the ODBCBCP snapshot files
that is posted into this table, while the files themselves are stored on a
share on the distributor. For merge replication the situation is different
and the distributor's job is to merely record metadata about replication -
dates of synchronization etc, but the data itself never flows through the
distributor - it remains on the publisher and subscribers.
HTH,
Paul Ibison
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||thanks Russell~~
|||Thanks Paul~