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

#001mvaish05 1 Reputation point

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.


SQL Server on Azure Virtual Machines
{count} votes

1 answer

Sort by: Most helpful
  1. Jingyang Li 5,311 Reputation points

    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 No comments