stacylaray (3/25/2015)
This is not supported as the code is updating the replication metadata tables. If the distributor server name changes from S1 to S2, the only supported way is to drop and recreate all replication. The distribution server name is hardcoded in the jobs, system tables, agent profiles and many other places. There will be issues if the distribution server changes as part of the update.The below code is updating replication metadata tables and it’s not supported:
10.Update MSpublisher_databases table with correct publisher id:
update t
set t.publisher_id =@srvid
FROM [$(DistributionDB)].[dbo].[MSpublisher_databases] t
Stacy Gray
Technical Advisor
Macrosoft
The code is valid and experienced SQL Server DBAs will save time, energy and nerves when distribution db needs to be moved to a new sql instance without downtime. Your comment shows limited knowledge of SQL Server replication and it should be removed. I have spoken to Microsoft and they will make it supported.
Regards,
V.