How to migrate SQL Server 2008 to Azure Sql Server 2016 AlwaysOn.
Find the details below:
SQL Server 2008 (Standalone) which contains around 50-60 databases and total size of all these Db's around 80 TB.
Almost all database are in Simple Recovery mode. Only 5-8 databases are in Full Recovery.
Now we are palnning to migrate all these DB's to Azure (SQL Server 2016) and configure Always with 2 secondary replicas.
Server are ready in Azure. Next, migrating 80 TB and configure Always.
Please help us what it is procedure to migrate 80 TB data?