Groups | Blog | Home
all groups > sql server replication > september 2004 >

sql server replication : Changing IP


ndpace NO[at]SPAM att.net
9/29/2004 11:39:22 AM
I am using merge replication with SQL ver 7, on a NT4 box. I need to
move one of seven subscribing servers to a new location which means
changing the IP address. I want to do the move without taking down
replication if possible. My plan is to move the box and change to new
IP address. Then update the WINS entry for the new address, and have
replication resume.

Should this work? Let me know if anyone can think of potential
problems.

Hilary Cotter
9/29/2004 3:33:15 PM
It should work. Replication is sensitive to subscriber name changes, not ip
address changes. Just make sure that you did not hard code an ip address in
the alias you may have created for this server in client network utility.

--
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html


[quoted text, click to view]

Siarhei Sinkevich
9/30/2004 2:20:02 PM
Guys!

I have the similar problem, but the server name will be changed also.

I believe it should be enough to call a kind of system SP, which will
replace old box names to the new ones. Could you point me to the right
direction?

Best regards,
Serge.


[quoted text, click to view]

Paul Ibison
10/1/2004 12:45:08 AM
Serge,
Use Master
go
Sp_DropServer 'OldName'
GO
Use Master
go
Sp_Addserver 'NewName', 'local'
GO
Stop and Start SQL Services
This will rename your server, but you'll need to set up
the publications from fresh afterwards.
HTH,
Paul Ibison

(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
AddThis Social Bookmark Button