I have an established transactional replication publisher and I would like to change the server that it uses as the distributor - from server A (SQL Server 2008) to server B (SQL Server 2012). Is there away to do that or do I have to script it all the publications and subscriptions, delete them and start over again? The publications and subscribers are not changing.
Thanks for the help,
Steve