Solved

Migrating to Office 365, need to keep SQL Server?

Posted on 2013-06-23
1
536 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

Learn by Doing. Anytime. Anywhere.

Do you like to learn by doing?
Our labs and exercises give you the chance to do just that: Learn by performing actions on real environments.

Hands-on, scenario-based labs give you experience on real environments provided by us so you don't have to worry about breaking anything.

Question has a verified solution.

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

A recent project that involved parsing Tableau Desktop and Server log files to extract reusable user queries for use in other systems. I chose to use PowerShell to gather the data, and SharePoint to present it...
Optimized for private cloud infrastructures and datacenters, Nano Server is minimalistic, yet super-efficient, OS for services such as Hyper-V and Hyper-V cluster. Learn how you can easily deploy Nano Server and unlock its power!
This Experts Exchange lesson shows how to use VBA to loop through rows in Excel.  In order to sort, filter, and use database features, there needs to be a value in each column for every row. When data arrives with values missing, code to copy values…
This is my first video review of Microsoft Bookings, I will be doing a part two with a bit more information, but wanted to get this out to you folks.

724 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