Solved

Migrating to Office 365, need to keep SQL Server?

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

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
sql query help 2 43
Updating a SharePoint list from an Excel spreadsheet 7 43
Import HyperV 2008 R2 Machine to HyperV 2016 2 56
Office 365 SSO and Shared Devices 6 41
If you don't know how to downgrade, my instructions below should be helpful.
Most of the applications these days are on Cloud. Cloud is ubiquitous with many service providers in the market. Since it has many benefits such as cost reduction, software updates, remote access, disaster recovery and much more.
Office 365 is currently available in five editions. Three of them are for business use: Office 365 Business Essentials, Office 365 Business, and Office 365 Business Premium. Two of them are for home/personal use: Office 365 Home and Office 365 Perso…
This is Part 3 in a 3-part series on Experts Exchange to discuss error handling in VBA code written for Excel. Part 1 of this series discussed basic error handling code using VBA. http://www.experts-exchange.com/videos/1478/Excel-Error-Handlin…

914 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

12 Experts available now in Live!

Get 1:1 Help Now