I have a SQL Server 2008 transactional replication setup as follows:
- 192.168.100.1 <-- Distributor
- 192.168.100.2 <-- Publisher
- 192.168.100.3 <-- Subscriber
Our network team want to change the IP address of the distributor, for example to: 192.168.200.1
Also, we want to move the publication database to a new server. so, the replication source (publisher) will be also moved and it will have a new IP address as well.
The subscriber will remain as is.
I cannot afford having long downtime as our systems are running for 24x7 and there are so many huge tables that are already in replication and generating a new snapshot will take long time to be replicated.
What is the best way to seamlessly re-configure the replication and keep my data in sync without rebuilding it from scratch