Skip to Content
0
Dec 09, 2020 at 03:17 AM

MSSQL migration to Azure

43 Views

Hi all,

We have an SAP BW 7.5 running on MSSQL 2014 with AO for DR purposes. The disk layout was poorly allocated/distributed across disk. We would like to migrate the system to Azure IAAS. I am thinking to setup another AO DB in Azure with MSSQL 2019.

First question is would it be possible to restore the DB to target and run r3load system copy to allow the datafiles to be reorganized ? Once completed, replay DB logs to allow it to catch up with primary DB ?

Second question is mixed OS & DB version possible ? Onpremise is running Windows 2012 & MSSQL 2014. Azure is Windows/SQL 2019.

Thanks,