Solved

Migrating to Office 365, need to keep SQL Server?

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

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

What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

Join & Write a Comment

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Create and license users in Office 365 in bulk based on a CSV file. A step-by-step guide with PowerShell script examples.
Microsoft Office Picture Manager has a Picture Shortcuts pane that shows a list with the Recently Browsed folders. While creating my video Micro Tutorial here at Experts Exchange showing How to Install Microsoft Office Picture Manager in Office 2013…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

760 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

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now