Hi,
Migration of Physical RDM is not supported, that is for sure, for all migrations types. Regardless if is HCX or a "normal" vCenter vMotion.
For there are two options.
1 - On destination, create a new SQL server and migrate Data/DB.
2 - Convert it to VMDK.
Using VMware converter or not, you will always have downtime on that SQL server.
Luciano Patrão
VCP-DCV, VCAP-DCV Design 2023, VCP-Cloud 2023
vExpert vSAN, NSX, Cloud Provider, Veeam Vanguard
Solutions Architect - Tech Lead for VMware / Virtual Backups
________________________________
If helpful Please award points
Thank You
Blog: https://www.provirtualzone.com | Twitter: @Luciano_PT