SharePoint Dragons

Nikander & Margriet on SharePoint

Keep relational data in a database or migrate it into a custom list

It’s an interesting question: should you keep relational data in a database or migrate it into a custom list? We’d love our readers to contribute to the discussion at the TechNet Wiki page at http://social.technet.microsoft.com/wiki/contents/articles/9638.sharepoint-2010-best-practice-keep-relational-data-in-a-database-or-migrate-it-into-a-custom-list.aspx

The discussion as it stands so far:

If you need relational database capabilities (transactionality, triggers, real constraints (not the approximation of that in SharePoint)): use the existing database (and create a BCS external list to access the data).

– Are there existing apps using the current relational database? If yes, create a BCS external list to access the data.

– If no reasons prevent it, migrate the data into a custom list as this makes the solution less complex.

You need to make sure you play nicely and keep the data within the limits of capacity planning (https://sharepointdragons.com/2011/12/05/sharepoint-capacity-planning/ ). If there is absolutely no way that you can’t, keep the data where it is.

Advertisements

2 responses to “Keep relational data in a database or migrate it into a custom list

  1. webparts360 April 19, 2012 at 8:39 am

    Check out http://www.webparts360.com where we make SP lists works exactly as relational database. Bonus: it also provides the ability to build ER diagrams to document the data model for easier use.

  2. webparts360 April 19, 2012 at 8:41 am

    Use webparts360 to make your custom lists behave like relational database. It evens allows you to build entity relationship diagrams to document your data model.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: