SQL 2000.
If I have a server setup to use a remote server for replication distribution can I actually change which server is the distributor?
Example
Server1 has publications
Server2 is distributor for Server1's Publication
Server3 is new hardware
Can i Make Server3 replace Server2 as the distributor?
How can I do this?No (and yes).
Microsoft says "No" (I have asked), the distributor server name cannot be changed. The reason is that this name is used in various replication system tables.
You can of course track down all system tables where the distributor name is used and change it. I tried it just for fun on a test system and it worked, but I would never do it on a production system and I would never recommend doing it to anybody.
Thursday, March 8, 2012
Changing Remote Distributor
Labels:
changing,
database,
distribution,
distributor,
microsoft,
mysql,
oracle,
remote,
replication,
server,
setup,
sql
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment