locked
ContentType VS BCS SQL RRS feed

  • Question

  • Hi,

    i' have to migrate an Access Application with some modification to a SharePoint Intranet. For some tables i have to customize forms to add and modify object depending on users roles exemple : table customer the administrator will have a different form than a simple user.

    My question is wich criteria do i consider to choose between those two solution :

    1-Defining a custom contenttype on SharePoint with custom form using infopath or aspx form to manipulate Data

    2-Defining the hole model in SQL with relation between Data and do all the CRUD on .NET and use a SharePoint for :

    • Master Page of this aspx CRUD operations
    • Search with BCS on those table
    • BCS for creating some views and reports

    My question is wich critera i have to consider between those two choice 

    Thanks for answer

    Sunday, March 4, 2012 9:58 PM

Answers

  • And the community response will be determined by what version of SharePoint you're using.  I'm going to go with 2007 Enterprise, but if you're using SharePoint 2010, you'll have different considerations and will need to ask in the correct forum.

    Steven Andrews | SharePoint Professional | http://www.twitter.com/backpackerd00d | https://baron72.wordpress.com/

    • Marked as answer by Kitano Monday, March 5, 2012 3:13 PM
    Monday, March 5, 2012 12:33 PM
    Answerer

All replies

  • And the community response will be determined by what version of SharePoint you're using.  I'm going to go with 2007 Enterprise, but if you're using SharePoint 2010, you'll have different considerations and will need to ask in the correct forum.

    Steven Andrews | SharePoint Professional | http://www.twitter.com/backpackerd00d | https://baron72.wordpress.com/

    • Marked as answer by Kitano Monday, March 5, 2012 3:13 PM
    Monday, March 5, 2012 12:33 PM
    Answerer
  • yes i'm using the SharePoint 2010
    Monday, March 5, 2012 1:52 PM