Re-Initialize subscription did not upload changes?

I'm doing a test.
I dropped a subscription on Subscriber-A
I performed some transactions on Subscriber-A.
I pushed a new subscription to it and indicated that it already had schema
and data.
I'm trying to get those new transactions to the publisher. I chose then to
re-initialize the subscription and checked the box to upload changes. But
the publisher never received those new transactions?
What may I try?
bob
It sounds like that you chose not to apply data and structure during
snapshot set up. Do you have the corresponding stored procedures in your
subscribers?
If not, that may be the first step to look at.
"Robert A. DiFrancesco" <bob.difrancesco@.comcash.com> wrote in message
news:OxqVBuswEHA.2876@.TK2MSFTNGP12.phx.gbl...
> I'm doing a test.
> I dropped a subscription on Subscriber-A
> I performed some transactions on Subscriber-A.
> I pushed a new subscription to it and indicated that it already had schema
> and data.
> I'm trying to get those new transactions to the publisher. I chose then
to
> re-initialize the subscription and checked the box to upload changes. But
> the publisher never received those new transactions?
> What may I try?
> bob
>

Registration edit for replication ?

I have a laptop on a LAN and I have pushed a new subscription to it. Now I
want to move the Laptop to its proper location (in another city for example)
and replicate to it via the internet.
Can I simply edit the server registration at the Publisher?
thank you,
bob
Bob,
assuming you don't intend to reinitialize, AFAIK there is no new
configuration necessarily required on the publisher. However, on the
subscriber there are various stipulations:
It'll need to be set up as a pull subscriber.
On the laptop you'll need to set up an alias in the client network utility
and place an entry in the hosts file to recognise the publisher.
For security, the pull agent will need to be set up to use SQL
authentication or passthrough windows authentication.
If you want to subsequently reinitialize, then changes will be necessary on
the publisher. You'll need to set @.enabled_for_internet = true so that FTP
can be used to download the snapshot.
HTH,
Paul Ibison
|||no. The subscriber in this case is probably set up for an push. Exactly how
is the publisher going to find the subscriber over the internet.
To get this to work you would have to update the lmhosts and/or the hosts
file for the new ip address, Client Network Utiltity for the new ip address.
Hilary Cotter
Looking for a book on SQL Server replication?
http://www.nwsu.com/0974973602.html
"Robert A. DiFrancesco" <bob.difrancesco@.comcash.com> wrote in message
news:eSDh92DZEHA.2408@.tk2msftngp13.phx.gbl...
> I have a laptop on a LAN and I have pushed a new subscription to it. Now
I
> want to move the Laptop to its proper location (in another city for
example)
> and replicate to it via the internet.
> Can I simply edit the server registration at the Publisher?
>
> thank you,
> bob
>