SOLVED

Migrate Access DB to Cloud

%3CLINGO-SUB%20id%3D%22lingo-sub-1211722%22%20slang%3D%22en-US%22%3EMigrate%20Access%20DB%20to%20Cloud%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1211722%22%20slang%3D%22en-US%22%3E%3CP%3EWe%20are%20in%20process%20of%20moving%20access%20db%20file%20from%20on-prem%20to%20cloud%20due%20to%202008%20servers.%20Need%20to%20do%20this%20soon%20and%20as%20a%20tactical%20decision.%26nbsp%3B%3C%2FP%3E%3CP%3EDoes%20anyone%20know%20if%20they%20are%20workable%20in%20Azure%20VM%20with%20Map%20drive%20solution.%20Also%20if%20there%20is%20any%20migration%20tool%20for%20offering%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAppreciate%20for%20a%20quick%20response%20on%20this.%3C%2FP%3E%3CP%3E%3CBR%20%2F%3EH%3C%2FP%3E%3CP%3E%40gra%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1211722%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAccess%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1213654%22%20slang%3D%22en-US%22%3ERe%3A%20Migrate%20Access%20DB%20to%20Cloud%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1213654%22%20slang%3D%22en-US%22%3E%3CP%20data-unlink%3D%22true%22%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521395%22%20target%3D%22_blank%22%3E%40Hitesh_Jansari%3C%2FA%3E%26nbsp%3BIt%20is%20possible%20to%20move%20your%20data%20from%20access%20to%20SQL%20Azure%2C%20yes.%20There%20is%20a%20tool%20that%20does%20this%2C%20called%20%3CA%20href%3D%22https%3A%2F%2Fwww.microsoft.com%2Fen-us%2Fdownload%2Fdetails.aspx%3Fid%3D54255%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3ESQL%20Server%20Migration%20Assistant%3C%2FA%3E.%26nbsp%3B%20You%20can%20%3CA%20href%3D%22https%3A%2F%2Fazure.microsoft.com%2Fen-us%2F%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Eobtain%20an%20Azure%20account%3C%2FA%3E%20for%20this.%20I%20am%20not%20sure%20whether%20an%20Azure%20VM%20would%20be%20the%20appropriate%20way%20to%20go.%20There%20are%20numerous%20considerations%20to%20account%20for.%26nbsp%3B%3C%2FP%3E%3CP%20data-unlink%3D%22true%22%3E%26nbsp%3B%3C%2FP%3E%3CP%20data-unlink%3D%22true%22%3EAmong%20other%20things%20to%20think%20about%20is%20performance.%20It's%20going%20to%20be%20impacted%20so%20don't%20just%20plunge%20into%20this%20decision%20without%20researching%20the%20options%20Azure%20offers.%3C%2FP%3E%3CP%20data-unlink%3D%22true%22%3E%26nbsp%3B%3C%2FP%3E%3CP%20data-unlink%3D%22true%22%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1213695%22%20slang%3D%22en-US%22%3ERe%3A%20Migrate%20Access%20DB%20to%20Cloud%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1213695%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20George%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20for%20the%20quick%20update%20on%20this.%3C%2FP%3E%3CP%3EDo%20you%20know%20if%20we%20move%20the%20Access%20DB%20into%20Azure%20VM%20and%20map%20a%20drive%20to%20end%20users.%20By%20testing%20it%20it%20will%20work.%20Are%20you%20foreseeing%20any%20blockers%20with%20this%3F%3C%2FP%3E%3CP%3E%3CBR%20%2F%3EBest%20Regards%2C%3C%2FP%3E%3CP%3E%3CBR%20%2F%3EHitesh%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1213830%22%20slang%3D%22en-US%22%3ERe%3A%20Migrate%20Access%20DB%20to%20Cloud%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1213830%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521395%22%20target%3D%22_blank%22%3E%40Hitesh_Jansari%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBlockers%3F%20Probably%20performance%20is%20going%20to%20be%20the%20most%20significant.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI've%20done%20something%20like%20this%20for%20a%20handful%20of%20clients%20and%20that%20has%20always%20been%20the%20number%20one%20problem.%26nbsp%3B%20However%2C%20we%20did%20not%20use%20an%20Azure%20VM%3B%20we%20connected%20directly%20to%20the%20Azure%20database.%20Therefore%2C%20I%20can't%20say%20that%20a%20VM%20would%20or%20would%20not%20make%20a%20difference.%20And%2C%20of%20course%2C%20we%20didn't%20try%20to%20map%20a%20drive%20in%20that%20configuration.%26nbsp%3B%3C%2FP%3E%3CP%3EKeep%20in%20mind%2C%20with%20any%20cloud%20solution%2C%20you're%20pushing%20and%20pulling%20data%20across%20a%20much%20longer%20wire.%26nbsp%3B%3CIMG%20class%3D%22lia-deferred-image%20lia-image-emoji%22%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Fhtml%2Fimages%2Femoticons%2Fsmile_40x40.gif%22%20alt%3D%22%3Asmile%3A%22%20title%3D%22%3Asmile%3A%22%20%2F%3E%20Also%2C%20network%20performance%2C%20internet%20connectivity%20and%20all%20that%20tend%20to%20be%20more%20critical%20to%20success.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1655878%22%20slang%3D%22en-US%22%3ERe%3A%20Migrate%20Access%20DB%20to%20Cloud%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1655878%22%20slang%3D%22en-US%22%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521395%22%20target%3D%22_blank%22%3E%40Hitesh_Jansari%3C%2FA%3E%3CBR%20%2F%3E%3CBR%20%2F%3EDid%20you%20make%20use%20of%20the%20Azure%20VM%3F%20I%20am%20having%20the%20same%20problems%20regarding%20our%20Access%20database.%20Could%20you%20please%20assist%20me%20with%20your%20findings%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1656135%22%20slang%3D%22en-US%22%3ERe%3A%20Migrate%20Access%20DB%20to%20Cloud%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1656135%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F789846%22%20target%3D%22_blank%22%3E%40RuleendeBeer%3C%2FA%3E%26nbsp%3BWe%20manage%20to%20do%20a%20PoC%20which%20seems%20that%20Azure%20VM%20can%20support%20AccessDB%20but%20wont%20be%20supported%20from%20Microsoft%20I%20believe%20as%20it%20is%20been%20deprecated.%20The%20only%20issue%20we%20faced%20was%20with%20the%20performance%20as%20we%20dont%20have%20express%20route%20in-place%20which%20can%20mitigate%20this%20issue.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHope%20this%20helps%2C%3C%2FP%3E%3CP%3E%3CBR%20%2F%3EBest%20Regards%2C%3C%2FP%3E%3CP%3E%3CBR%20%2F%3EHitesh%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1663815%22%20slang%3D%22en-US%22%3ERe%3A%20Migrate%20Access%20DB%20to%20Cloud%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1663815%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521395%22%20target%3D%22_blank%22%3E%40Hitesh_Jansari%3C%2FA%3E%26nbsp%3BUsing%20a%20VM%20to%20host%20the%20Access%20and%20trying%20to%20map%20it%20is%20a%20bad%20choice.%3C%2FP%3E%3CP%3EAccess%20is%20very%20touchy%20when%20it%20comes%20to%20network%2C%20it%20want's%20it%20to%20be%20solid%2Cfast%20without%20any%20lag%2Cso%20Internet%20is%20a%20no%20go%20as%20moving%20your%20file%20server%20to%20the%20cloud.%3C%2FP%3E%3CP%3EThe%202%20options%20are%3C%2FP%3E%3CP%3E1.%20RDS%2C%20host%20Access%20to%20it%20and%20RPD%20it...pros%20%3A%20it%20would%20be%20very%20fast%20and%20convenient%2C%20cons%3A%20then%20license%20price%3C%2FP%3E%3CP%3E2.%20Cloud%20BE%2C%20you%20will%20migrate%20the%20tables%20to%20SQL%20%2Cpros%20%3A%20a%20lot%2C%20cons%20%3A%20it%20requires%20quite%20some%20work%20to%20make%20it%20work%20as%20it%20should...remember%20SQL%20is%20not%20a%20file%20server%2C%20so%20don't%20treat%20it%20like%20one.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1664009%22%20slang%3D%22en-US%22%3ERe%3A%20Migrate%20Access%20DB%20to%20Cloud%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1664009%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F401564%22%20target%3D%22_blank%22%3E%40tsgiannis%3C%2FA%3E%26nbsp%3BAgree%2C%20not%20great%20using%20AccessDb%20in%20the%20cloud.%20We%20are%20looking%20using%20PowerApp%20to%20remediate%20some%20of%20these%20for%20tactical%20solution.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Contributor

We are in process of moving access db file from on-prem to cloud due to 2008 servers. Need to do this soon and as a tactical decision. 

Does anyone know if they are workable in Azure VM with Map drive solution. Also if there is any migration tool for offering?

 

Appreciate for a quick response on this.


H

@gra

 

7 Replies
Highlighted

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

 

 

 

Highlighted

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

Highlighted
Best Response confirmed by Hitesh_Jansari (Occasional Contributor)
Solution

@Hitesh_Jansari 

 

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. :smile: Also, network performance, internet connectivity and all that tend to be more critical to success. 

 

 

 

Highlighted
@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?
Highlighted

@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

Highlighted

@Hitesh_Jansari Using a VM to host the Access and trying to map it is a bad choice.

Access is very touchy when it comes to network, it want's it to be solid,fast without any lag,so Internet is a no go as moving your file server to the cloud.

The 2 options are

1. RDS, host Access to it and RPD it...pros : it would be very fast and convenient, cons: then license price

2. Cloud BE, you will migrate the tables to SQL ,pros : a lot, cons : it requires quite some work to make it work as it should...remember SQL is not a file server, so don't treat it like one.

Highlighted

@tsgiannis Agree, not great using AccessDb in the cloud. We are looking using PowerApp to remediate some of these for tactical solution.