Tayler Odling Posted September 24, 2021 Share Posted September 24, 2021 Hi, guys! Has everyone tried to use SharePoint Online as a database? I thought it could be pretty convenient. Any good practices? 1 Quote Link to comment Share on other sites More sharing options...
decoz Posted September 24, 2021 Share Posted September 24, 2021 Hey,@Tayler Odling! Never heard of someone actually doing it. Are you sure it's a good idea? 1 Quote Link to comment Share on other sites More sharing options...
Official Moderator Posted September 27, 2021 Share Posted September 27, 2021 Hi, @Tayler Odling! It isn't the best idea, even though it might seem like a simple and effective solution. SharePoint was intended to store the documents centrally. So, it lacks various aspects of a complete database solution, for example: SharePoint doesn't offer an organization that database should have. In SharePoint, one-to-one, one-to-many, many-to-many relationships are impossible. SharePoint can't handle significant volumes of data. It isn't recommended to have more than 2000 items on a list. SharePoint can't roll back changes. It doesn't offer the rollback of transactions. Of course, if you simply need structured storage for a few documents, SharePoint can work well in this case, but it isn't a solution for bigger volumes and crucial data. You can check a more detailed explanation in our blog post https://www.nakivo.com/blog/why-you-shouldnt-use-sharepoint-online-as-a-database/ Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.