Hi All
I have built a split Access database, however upon deployment its works painfully slow over WAN (using company VPN connecting to HQ file server).
I know I have basically two options:
1. Run a Microsoft SQL server on one of our servers and convert the tables to SQL using the SSMA tool.
I dont know a lot about SQL servers but from the research I have done so far it seems fairly simple, I install Microsoft SQL server on one of our HQ servers, then using the SSMA tool I convert my Access Database to Frontend/SQL Backend, fix any errors (I dont think there should be many, its a reletively simple Database and its just the tables) and then it should work?
My questions are:
How much of a performance increase should I expect? Over WAN with the current split database its painfully slow to the point its unusable, will converting to SQL backend make it workable for a small company (50 employees spread over 5 cities, not all using it at the same time, would be odd if 5 people used it in a day)?
What potential issues should I expect, will my queries/forms still work with SQL backend tables, they can be quite complicated?
2. Do the same but host with Microsoft Azure
From research this is the fastest option, however does anyone have any experience with Microsoft Azure SQL, the website seems like its targetting massive multinationals for large projects integrating multiple systems and functions, all I want is a fast/smooth SQL database for a Access frontend to work with, I couldnt quite figure out the costs either as the pricing calculator came out at over 2k a month which seems massively excessive.
Are there other options available?
Thanks