Solved

Move an Access database into Azure

Posted on 2014-12-15
9
546 Views
Last Modified: 2014-12-29
I have a customer who has a database that needs to be available from two locations. I know there is the option of setting up a VPn between the sites but I would really like to use Azure to enable this.

I am fairly new to Azure and I am unsure exactly what is the best option.

I am also fairly unfamiliar with MS Access. Is has a customised front end interface and the database consists of an .mdb and a .mde file.

Azure SQL is one option. Would this work well over a 5meg broadband connection.

I also see the Remote App is something new from Azure which would allow true access from anywhere. Is it possible to set a Access "Remote App" to default to a database stored in Azure SQL.

Any advice would be appreciated.
0
Comment
Question by:roy_batty
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
  • 2
  • +1
9 Comments
 
LVL 84

Accepted Solution

by:
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 350 total points
ID: 40500364
If you're unfamiliar with Access and Azure, then I'd say you'll have a tough time with this. Azure is, essentially, a cloud-based SQL Server. If your Access application is already optimized to work with a SQL Server database, then the move to Azure most likely wouldn't be too painful - basically you'd just move the database to Azure, then connect to that from your FE.

If your Access db is not optimized, then the first step would be to do so. That can be a big task, depending on exactly what needs to be migrated.

Note also that many who have done what you're doing have reported performance issues with Azure-based systems. Access itself is not optimized to deal with cloud-based systems, whereas .NET or other more advanced platforms are able to interact with cloud-based systems much more effectively.

A better option, in my opinion, is to use a Citrix or RDS (Remote Desktop Services) sort of configuration. These allow remote users to log into a RDS/Citrix server, and the users can run programs exactly as they do on their local desktops. Of course, there's expense involved in purchasing and setting up these environments.

There's also www.eqldata, which allows "hosting" of Access databases. There's a monthly fee for use, but it's by far the simplest way to handle this sort of thing.
0
 
LVL 50

Expert Comment

by:Gustav Brock
ID: 40500791
If you only have one or two users at the other location, a remote desktop will be far the easiest and cheapest method.
A 5 Mb/s line is amble for this.

Can you provide some more info?

/gustav
0
 
LVL 36

Assisted Solution

by:PatHartman
PatHartman earned 150 total points
ID: 40501461
I've developed hundreds of Access applications with SQL Server back ends so I thought Azure would be a good option - didn't work out.  I was using a third party to host the Azure and that may have been part of the problem but performance was dismal.  The only people I have talked to who were happy with Azure performance were hosting it themselves so they had internal people who could tune it correctly.

My vote is Citrix or RDS.  If you have only a few people to support, it is probably cheaper to by a hosted Citrix solution rather than install a server and manage it yourself.  RDS is much more limited.  I've used that to connect to a couple of clients but in all cases, I had a "personal" computer at the site that I connected to.  I didn't connect to a shared server.
0
Online Training Solution

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.

 
LVL 84
ID: 40501569
but performance was dismal.
That's the same thing I've heard from numerous sources. From my view, just stay away from it in the Access arena.
0
 
LVL 1

Author Comment

by:roy_batty
ID: 40501710
OK so if I am going to use Azure it could be done by setting up a RDS server with Access installed on it.

The EQLDATA option also looks fairly straight forward and is something I have not heard of before. Do you have any experience with it and is it reliable. It looks fairly pricey when you go beyond one user and might be more expensive than setting up a RDS server in Azure.
0
 
LVL 50

Expert Comment

by:Gustav Brock
ID: 40502316
>  a RDS server [or workstation] with Access installed on it.

It could be installed in-house as well. Still, we don't have any indication of the expected user count.

/gustav
0
 
LVL 84
ID: 40502623
I've not used it, but we've heard good things about eqldata.

OK so if I am going to use Azure it could be done by setting up a RDS server with Access installed on it.
I've not heard of doing that, but blog posts seem to indicate you could do so. Note that when running Access in the RDS environment, you must purchase Volume Licensing for the product (Office). That wasn't true in earlier versions of RDS, where you were on the honor system (i.e. you were expected to purchase the required number of licenses). MSFT made changes in recent versions to disallow the use of software not properly licensed in the RDS environment.

My point in mentioning this is to inform you of additional costs associated. I still think an RDS setup (or Citrix) is the better choice here.
0
 
LVL 36

Expert Comment

by:PatHartman
ID: 40502832
The only time you would use Azure is if you are connecting directly over the internet.  If you are running the app on your server and having people remote in, then you would use regular SQL Server.  There is no difference between the products from the perspective of development.  The difference is that Azure is intended to be "cloud" based and it has tighter security.

Again, people who host Azure on-site report good performance.  It is the third party options that are not good because  Access is not a major player in this market and the providers don't understand (nor are they interested in understanding) how to make the two work well together.
0
 
LVL 1

Author Closing Comment

by:roy_batty
ID: 40522842
Thanks for the advice here
0

Featured Post

ScreenConnect 6.0 Free Trial

Explore all the enhancements in one game-changing release, ScreenConnect 6.0, based on partner feedback. New features include a redesigned UI, app configurations and chat acknowledgement to improve customer engagement!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Previously, on our Nano Server Deployment series, we've created a new nano server image and deployed it on a physical server in part 2. Now we will go through configuration.
Azure Functions is a solution for easily running small pieces of code, or "functions," in the cloud. This article shows how to create one of these functions to write directly to Azure Table Storage.
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
Connecting to an Amazon Linux EC2 Instance from Windows Using PuTTY.

730 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question