MSSQL migration to Azure

[hari_amirchow]

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,

[hari_amirchow]

Hi Clas,

Thank you so much for respond. That's a very good point. I guess I have to look for ways to reorganize the DB datafiles from MSSQL point of view.

Regards,

Harie

[clas_hortien]

Hello,

you cannot mix a restore of the DB with a r3load of the DB. You can restore a SQL 2014 DB to a SQL 2019 and you can apply SQL 2014 transaction logs later, the OS that the server are running on is not important. But you can't redistribute the data with this approach. This only can be done with r3load, but this is then a one-step migration as you can't apply transaction logs later. You have to migrate with r3load the DB e.g. in a weekend and then use this new DB, you cannot transfer any change from the original DB into this newly created DB later on.

Best regards

Clas