Groups | Blog | Home
all groups > sql server replication > may 2006 >

sql server replication : How to rename a publisher


Jorge Martinez
5/4/2006 8:52:54 AM
Good morning, i have a SQL 2000 with a Merge Replication on a server, i want
to move the publisher (and the distributor) to another server, which has a
diferent name.

I can´t rename the new server, could run my replication on that server ? or
when i attach the databases the replication fails.

Thanks

Paul Ibison
5/4/2006 9:03:34 AM
Jorge,
you'll need to script out the publications, change the servername in the
script then add back in and initialize.
To minimise the work you could do a nosync initialization.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)

AddThis Social Bookmark Button