locked
Do sql on wss3.0 Database RRS feed

  • Question

  • This is a development of sql scripts on a wss3.0 db.

    We have SQL programmers and they want to intergate the wss3.0 database. They do not want to use API'S
    Has anyone created a sql procs for the following.

    PLEASE NOTE ITS READING THE DB AND NOT WRITING TO IT.

    select subsites from mainsite
    select column1 from listitem where subsite=a and main site=b
    Read of any type of column for a list item whether text,richtext,dropdown lookup, choice, workflow status
    Do a couple of joins between SQL

    Now this can be all a view or functions but it has to be in in SQL. What is the best stratagy
    a Batch job to extract data ? , create views ? ............

    Wednesday, November 11, 2009 10:48 AM

Answers

  • By adding a view or stored proc you are modifying the database.  If you want to use a server product like SharePoint you need to use the integration points which are APIs and Web Services.
    My SharePoint Blog - http://www.davehunter.co.uk/blog
    • Proposed as answer by Magnus Johansson Wednesday, November 11, 2009 11:00 AM
    • Marked as answer by Mike Walsh FIN Wednesday, November 11, 2009 11:10 AM
    Wednesday, November 11, 2009 10:59 AM

All replies

  • By adding a view or stored proc you are modifying the database.  If you want to use a server product like SharePoint you need to use the integration points which are APIs and Web Services.
    My SharePoint Blog - http://www.davehunter.co.uk/blog
    • Proposed as answer by Magnus Johansson Wednesday, November 11, 2009 11:00 AM
    • Marked as answer by Mike Walsh FIN Wednesday, November 11, 2009 11:10 AM
    Wednesday, November 11, 2009 10:59 AM
  • Hi.

    It doesn't matter if you say you "reading the db". It's still unsupported .

    "Examples of such database changes include, but are not limited to, the following: Reading from the database"

    Regards,
    Magnus
    My blog: InsomniacGeek.com
    Wednesday, November 11, 2009 10:59 AM
  • As mentioned before your WSS will fall into a unsupported state.

    Your problem seems to be

    "We have SQL programmers and they want to intergate the wss3.0 database. They do not want to use API'S"


    For those who only know a hammer as a tool each problem will look like a nail. So expand your toolkit and train your programmers or get some stuff experienced either in WSS/MOSS or Webservices.
    Wednesday, November 11, 2009 11:10 AM