Migrate distributor and work database from one server to another
We have a database called work and distributor database. we had setup replication on work database and devices in field. How do we migrate the work database to another and distributor db to another server. do we have to setup replication again? This is on SQL Server 2008 R2.