Forum Discussion
Migrate Access DB to Cloud
Blockers? Probably performance is going to be the most significant.
I've done something like this for a handful of clients and that has always been the number one problem. However, we did not use an Azure VM; we connected directly to the Azure database. Therefore, I can't say that a VM would or would not make a difference. And, of course, we didn't try to map a drive in that configuration.
Keep in mind, with any cloud solution, you're pushing and pulling data across a much longer wire.
Also, network performance, internet connectivity and all that tend to be more critical to success.
Hi George,
Thanks for the quick update on this.
Do you know if we move the Access DB into Azure VM and map a drive to end users. By testing it it will work. Are you foreseeing any blockers with this?
Best Regards,
Hitesh
Blockers? Probably performance is going to be the most significant.
I've done something like this for a handful of clients and that has always been the number one problem. However, we did not use an Azure VM; we connected directly to the Azure database. Therefore, I can't say that a VM would or would not make a difference. And, of course, we didn't try to map a drive in that configuration.
Keep in mind, with any cloud solution, you're pushing and pulling data across a much longer wire. Also, network performance, internet connectivity and all that tend to be more critical to success.
- Hitesh_Jansari
Did you make use of the Azure VM? I am having the same problems regarding our Access database. Could you please assist me with your findings?RuleendeBeer We manage to do a PoC which seems that Azure VM can support AccessDB but wont be supported from Microsoft I believe as it is been deprecated. The only issue we faced was with the performance as we dont have express route in-place which can mitigate this issue.
Hope this helps,
Best Regards,
Hitesh
