Hi,
we are planning a cloud migration of our current on-prem Sql server db.
our on-prem is a SQL 2012 system.
we are exploring the option to migrate to either a) SQL Managed Instance 2019 or b) Sql Server 2019 on Azure VM
One of the factors to decide on the options, is which one supports easier rollback.
On go-live, if for some reason we have to roll-back after a few hours of go-live,
will i able to take a backup from Sql MI or SQl Server 2019 VM and restore it back to our on-prem 2012.
Please can anyone share their experiences.
Thanks