Solved

Migrating to Office 365, need to keep SQL Server?

Posted on 2013-06-23
1
533 Views
Last Modified: 2014-11-12
We are interested in using Office 365 Enterprise E3. We have SQL Server as a backend to Access forms for our users. Ideally, we'd like to mirror our in-house SQL Server data for web / Sharepoint / Office App access by remote users. Would we need SQL Azure also and is SQL Azure compatible with Office 365 anyway? I also cannot find info about limitations on the web site space with Office 365 E3 and whether PHP etc. can be used with it.

Anyone know?
0
Comment
Question by:machine_run
[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
1 Comment
 
LVL 32

Accepted Solution

by:
Jamie McAllister MVP earned 500 total points
ID: 39270511
This is a complicated topic. It sounds like you're at the point where you want to make an assessment of whether a hybrid on-prem/O365 environment is for you.

I'd read this and the related articles as a starting point; http://blogs.technet.com/b/tothesharepoint/archive/2013/04/16/get-your-head-in-the-cloud-hybrid-for-sharepoint-2013-office.aspx

http://technet.microsoft.com/en-us/library/jj838715.aspx

The thing is that O365 isn't set up for you to extend it in the way you can with an on-premises install. Boosting storage with your own SQL Server or hosting PHP on it are not in the picture. As O365 is shared with other customers outside your organisation customizations have major limitations.

As for storage in O365 the service description has the details here; http://www.microsoft.com/en-us/download/details.aspx?id=13602

Broadly speaking it's down to the number of users you have signed up.
0

Featured Post

Webinar: Aligning, Automating, Winning

Join Dan Russo, Senior Manager of Operations Intelligence, for an in-depth discussion on how Dealertrack, leading provider of integrated digital solutions for the automotive industry, transformed their DevOps processes to increase collaboration and move with greater velocity.

Question has a verified solution.

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

The following article is comprised of the pearls we have garnered deploying virtualization solutions since Virtual Server 2005 and subsequent 2008 RTM+ Hyper-V in standalone and clustered environments.
My attempt to use PowerShell and other great resources found online to simplify the deployment of Office 365 ProPlus client components to any workstation that needs it, regardless of existing Office components that may be needing attention.
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code. This l…
how to add IIS SMTP to handle application/Scanner relays into office 365.

734 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