Sign in
Microsoft.com
 
Microsoft
 
 
 
Microsoft >
> 
> 
sql table vs sharepoint list

Traitée sql table vs sharepoint list

  • Thursday, May 24, 2012 4:54 AM
     
     
    Sign In to Vote
    0

    hi All,

    I would like to understand the factors we should consider for deciding whether to go for sharepoint lists or sql tables.

    I have already gone through below link:

    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    http://msdn.microsoft.com/en-us/library/ff647105.aspx

    Thanks, Nilesh

    • Moved by Ed Price - MSFTMicrosoft Employee Friday, June 01, 2012 10:51 PM By request (From:MSDN, TechNet, and Expression Profile and Recognition System Discussions)
    •  
     

All Replies

  • Thursday, May 24, 2012 12:17 PM
     
     Proposed Answer
    Sign In to Vote
    1

    Hi,

    wrong forum - ask her:

    http://social.msdn.microsoft.com/Forums/en-US/sharepoint2010general/threads 

    Regards

    Oliver

     
  • Friday, May 25, 2012 2:53 AM
     
     
    Sign In to Vote
    1
    I know it is wrong forum, This site was not allowing me to post this in sharepoint forum and i thought the coordinators would help me in this.

    Thanks, Nilesh

     
  • Friday, May 25, 2012 7:23 AM
     
     
    Sign In to Vote
    1

    Hi Nilesh,

    what exactly is your problem. I have tested  the "Ask a question" feature. Works fine for me.

    Regards

    Oliver

     
  • Friday, June 01, 2012 10:50 PM
     
     
    Sign In to Vote
    0
    I know it is wrong forum, This site was not allowing me to post this in sharepoint forum and i thought the coordinators would help me in this.

    Thanks, Nilesh

    Nilesh, I am moving this question to the SP2010 General forum.

    Thanks!

    Ed Price (a.k.a User Ed), SQL Server Experience Program Manager (Blog, Twitter, Wiki)

     
  • Saturday, June 02, 2012 2:32 AM
     
     Answered
    Sign In to Vote
    0

    Nilesh, can you be a little more specific about what you are wanting to know. The link you have already gone through is what I would have linked if you had not said you had already gone through it.

    I would boil it down to...

    If you expect to have lots of data (generally more than 2,000 rows) and/or need to do even moderately complex joins between lists/tables and/or need to handle a decent transactional load, use SQL. Otherwise use SharePoint.

    Of course, SQL is more complex to use and therefore requires additional expertise. There may be additional cost depending on how your current environment is setup and how you plan to use SQL, if you go that route. Some companies push SharePoint to it's limits for those reasons and try to use SharePoint as much as possible.

    Doug Hemminger http://www.sharepointdoug.com

     
  • Saturday, June 02, 2012 3:14 PM
     
     
    Sign In to Vote
    0
    Indeed, the link summarizes everything !

    Serge Luca; SharePoint MVP ; blog: http://sergeluca.wordpress.com/ Devoteam Belgium. http://twitter.com/sergeluca