Hi @American Water BE,
Thanks for reaching out to Microsoft Q&A.
Please see below points:
- For high performance solutions, I would recommend using Express routes if budget is not a constraint
- For temporary requirements which is not a long term, you can go with Point to Site VPN for VM and use hybrid connections for less frequent and light access.
For quick comparisons, please see this reference link- https://techcommunity.microsoft.com/blog/fasttrackforazureblog/azure-vpn-gateway-vs-expressroute---quick-comparison/3725670
For DB migration, you can use DB migration services for moving DB to azure. Reference Link: https://azure.microsoft.com/en-us/products/database-migration/?msockid=2077390ab4af66e105de2d1bb5a9679e
Please do not forget to "Accept the answer” and “up-vote” wherever the information provided helps you, this can be beneficial to other community members.