We are planning to migrate two servers with MSSQL 2012 servers with configured transactional replication. New servers will have new names, ip addresses and MSSQL 2014. Subscriber is used for reporting and there are extra tables and columns needed for reporting that does not exist on publisher. What will be best way to migrate those servers? We will have enough downtime to do all needed works.
Some extra columns on reporting server are calculated on daily basis, and we would like to restore it from backup too, if that is possible.