Hello, I'm currently building a new SQL 2K8 server that will act as a replication publisher/distributer and will replace an existing one that we have (on a very underpowered box). I've got the all of the subscriptions/publications setup on this new server and I'd now like to point all my production boxes away from the old server to the new server. Just wondering what the cleanest way of doing this is? Ideally we don't want any downtime and the databases are fairly large so I'm not so sure reinitializaing the subscriptions on these production servers is a very good idea. Is it possible to simply repoint these production servers so instead of pulling subscriptions from the old server they now go to the new server? Any assistance would be greatly appreciated!
Virtually you have a huge UPGRADE project here whereby you are replacing the current replication setup, which means see http://sqlserver-qa.net/blogs/6070.aspx post which refers on that aspect and http://msdn.microsoft.com/en-us/library/aa176623(SQL.80).aspx and http://sqlblogcasts.com/blogs/ssqan...-practices-choose-optimal-upgrade-option.aspx too.