Moving SQL to a hosted server

by S Chase   Last Updated January 03, 2018 04:06 AM

I'm in the process of moving a large (7GB-9GB) database to a hosted server. the old server uses SQL 2008 R2 and the new one is using SQL 2016. I'm trying to find the best way to reduce the downtime for this migration. I've looked into mirroring and replications and don't think either really fits the situation. I'm hoping I'm wrong and there's something I can use that I'm just not looking at properly.

Is it possible to set up a mirror or something in this manner and then once I drop the primary just disable it?

I have full access to both servers but may need to have firewall ports opened if needed.

Related Questions

Mirroring and Replication

Updated November 14, 2017 08:06 AM

SQL Server replication for off site copy

Updated March 28, 2018 11:06 AM

Having DB Mirroring and Replication together

Updated May 13, 2015 12:40 PM