Cloud based environment for Access/MSSQL apps

While I'm moving into the JavaScript framework universe, I've been increasingly exposed to Platform as a Service (PaaS) options like Heroku and Azure. That-being-said, I don't every think I'll leave my old MS Access / MSSQL databases behind entirely.

Here's what I'd love - A Heroku-ish or Azure-ish platform to which I could point my subcontractors and instruct them fully deploy the MS Access/MSSQL application on which they're working to a point where my QA/QC subcontractors or I can test it fully.

Sure, I could setup a VM on a Windows box, install MSSQL, and MS Access, and give my subs remote access, but I want to someone else to take care of the process for me. I'm happy to pay well for such a service.

Suggestions are appreciated.
jdanaAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Scott Fell, EE MVEDeveloper & EE ModeratorCommented:
>Here's what I'd love - A Heroku-ish or Azure-ish platform to which I could point my subcontractors and instruct them fully deploy the MS Access/MSSQL application

Then use Azure with sql server http://azure.microsoft.com/en-us/services/sql-database/ but it is time to loose ms access if this is the direction you want to go (and it is a good direction).

The other platforms will typically have their own data stores such as https://www.parse.com/docs/data or https://cloud.google.com/sql/docs?_ga=1.83986649.192558782.1425300791 and all the rest... but I think Azure will be the only one with ms sql server.  http://azure.microsoft.com/en-us/services/sql-database/
0
btanExec ConsultantCommented:
most of the time, you will be getting the list of PaaS candidates such as Cloud Foundry, Microsoft Azure, Google App Engine, Amazon, Heroku, and OpenShift. Will be good to have them compared with their level of capability in
a) transparency in handling all assigned resource pool and workload type of platform,
b) provisioning of readily development tooling (GUI, command line, script, trigger, batch job, scheduled),
c) ability to trigger and review entire integration services and lifecycle (including area of security),
d) clear proven SLAs track and assurance in platform provisioning,
e) dynamic or static data stores and means (going down to granularity of CSV type, column/row based, statistical etc),
f) support of various programming models (in like of Ruby, Node.js, Python, Java, and PHP and their modeling support),
g provide customer with oversight and management as required (more of like KPI reporting assurance and maturity).

This also in reference to a comparison (in slideshare)done by IBM (though it can be geared towards CloudFoundary), but thought it is of interest since open to various ideas. The datastore (MSSQL etc) part (slide 8)  is shared with "higher" level given the Azure and AWS inclusive also (of course) CF. They also mentioned No-SQL too (probably gaining traction and attention against relational DB). The pro and cons are something worth noting too.

Just my few cents ...
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Mike SmithEnterprise VoIP & ISP BrokerCommented:
@phoffric, Sorry, my fault.  I didn't know but won't self promote our stuff in the future.
0
jdanaAuthor Commented:
Great answers. Thanks guys.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Cloud Services

From novice to tech pro — start learning today.