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.
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.
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
