Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 changing a replication package

Author  Topic 

jamie
Aged Yak Warrior

542 Posts

Posted - 2004-07-27 : 07:28:41
hi,
I have a replication running that copies a database to another server.
this other server is having its ipaddress changed.
at present the replication uses the ipaddress.
I was planning on just modifiying the ipaddress to the servers hostname. in the one push subscribion that is used.
is this a wise thing to do, or would I be better off creating a new publication to the subscriber ?
I've been told if I create a new publication to the subscriber will would need to copy the whole database over, this is a 2 gig db.
what are your thoughts on the subject ?

thanks.
J

   

- Advertisement -