?
Solved

Migrating to Office 365, need to keep SQL Server?

Posted on 2013-06-23
1
Medium Priority
?
541 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
1 Comment
 
LVL 32

Accepted Solution

by:
Jamie McAllister MVP earned 2000 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

Fill in the form and get your FREE NFR key NOW!

Veeam is happy to provide a FREE NFR server license to certified engineers, trainers, and bloggers.  It allows for the non‑production use of Veeam Agent for Microsoft Windows. This license is valid for five workstations and two servers.

Question has a verified solution.

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

Microsoft Office Picture Manager was included in Office 2003, 2007, and 2010, but not in Office 2013. Users had hopes that it would be in Office 2016/Office 365, but it is not. Fortunately, the same zero-cost technique that works to install it with …
A while back, I ran into a situation where I was trying to use the calculated columns feature in SharePoint 2013 to do some simple math using values in two lists. Between certain data types not being accessible, and also with trying to make a one to…
Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…
A company’s greatest vulnerability is their email. CEO fraud, ransomware and spear phishing attacks are the no1 threat to a company’s security. Cybercrime is responsible for the largest loss of money to companies today with losses projected to r…

850 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