SQL server 2008 Failover Cluster migration with 100 databases (10 TB) to SQL server 2014 on Azure VM

mvaish0141 1 Reputation point
2020-05-23T23:34:54.157+00:00

Hi,
I have a SQL server 2008 Failover Cluster on premise with ~100 databases (~10 TB) that I want to migrate to SQL server (SQL server 2014) on Azure VM (Windows Server 2012 R2 datacenter).

Migration method under consideration is bulk data migration using Azure DataBox.

  1. Is this realistic approach?
  2. What are the options for syncing data between on-prem SQL server and SQL server on VM
  3. Which other migration method is available.

Thanks,
V

SQL Server on Azure Virtual Machines

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Jingyang Li 5,891 Reputation points
    2020-06-19T03:13:01.377+00:00

    You can use Powershell based dbaTools to migrate your databases as an option. Give it a try.
    Here is the link: dbatools.io

    0 comments