Saturday, February 25, 2012

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
>

No comments:

Post a Comment