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.
Hitesh_Jansari It is possible to move your data from access to SQL Azure, yes. There is a tool that does this, called SQL Server Migration Assistant. You can obtain an Azure account for this. I am not sure whether an Azure VM would be the appropriate way to go. There are numerous considerations to account for.
Among other things to think about is performance. It's going to be impacted so don't just plunge into this decision without researching the options Azure offers.
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,
HiteshBlockers? 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?
