how to active a push subscriptin?

Hi all:
How to active a push subscription after created push subscription?
Cheers
nick
Drop the push subscription. At the publisher or distributor if you have a
remote distributor go to Tools, Replication, Configure Publishing,
Distributor, Subscribers. Enable your subscriber. The connect to the
subscriber, enable replication. After this go to tools, replication, create
pull subscription. Follow the prompts.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Nick" <fsheng@.ebreathe.co.nz> wrote in message
news:OnRBILjCFHA.2876@.TK2MSFTNGP12.phx.gbl...
> Hi all:
> How to active a push subscription after created push subscription?
>
> Cheers
> nick
>
|||Thanks Hilary
can i ask one more question about push subscription?
i got two DB in my SQL server, call A, B for exampl. A is a publication DB,
B is push subscription DB, so whenever data been changed in B database that
will be updated in A database,
is that good way to manage in this situation?
Cheers
Nick
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:#Mme7OjCFHA.4036@.TK2MSFTNGP15.phx.gbl...
> Drop the push subscription. At the publisher or distributor if you have a
> remote distributor go to Tools, Replication, Configure Publishing,
> Distributor, Subscribers. Enable your subscriber. The connect to the
> subscriber, enable replication. After this go to tools, replication,
create
> pull subscription. Follow the prompts.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "Nick" <fsheng@.ebreathe.co.nz> wrote in message
> news:OnRBILjCFHA.2876@.TK2MSFTNGP12.phx.gbl...
>
|||No, its not. Push and pull do not refer to the direction of data movement.
Rather they refer to whether the changes are pushed from the publisher to
the subscriber, or whether the changes are pulled from the publisher to the
subscriber.
This is only valid for transactional or snapshot replication.
If you have snapshot or transactional replication with updatable
subscribers, changes which occur on the subscriber can be pushed from the
subscriber to the publisher. With merge, if you have a push subscription,
the changes are merged at the publisher and pushed to the subscriber. If you
have a pull merge subscription, the changes are merged at the publisher and
pulled to the subscriber.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Nick" <fsheng@.ebreathe.co.nz> wrote in message
news:u4qlYujCFHA.1396@.TK2MSFTNGP14.phx.gbl...
> Thanks Hilary
> can i ask one more question about push subscription?
> i got two DB in my SQL server, call A, B for exampl. A is a publication
DB,
> B is push subscription DB, so whenever data been changed in B database
that[vbcol=seagreen]
> will be updated in A database,
> is that good way to manage in this situation?
> Cheers
> Nick
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:#Mme7OjCFHA.4036@.TK2MSFTNGP15.phx.gbl...
a
> create
>
|||Hi Hilary:
Do you mean only transactional or snapshot replication can handle this case,
but not merge replication?
Cheers
nick
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:eTUf#0mCFHA.3376@.TK2MSFTNGP12.phx.gbl...
> No, its not. Push and pull do not refer to the direction of data movement.
> Rather they refer to whether the changes are pushed from the publisher to
> the subscriber, or whether the changes are pulled from the publisher to
the
> subscriber.
> This is only valid for transactional or snapshot replication.
> If you have snapshot or transactional replication with updatable
> subscribers, changes which occur on the subscriber can be pushed from the
> subscriber to the publisher. With merge, if you have a push subscription,
> the changes are merged at the publisher and pushed to the subscriber. If
you
> have a pull merge subscription, the changes are merged at the publisher
and[vbcol=seagreen]
> pulled to the subscriber.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "Nick" <fsheng@.ebreathe.co.nz> wrote in message
> news:u4qlYujCFHA.1396@.TK2MSFTNGP14.phx.gbl...
> DB,
> that
have
> a
>