RE: Question
"Price, Randall" <[email protected]>
| Newsgroups | gmane.comp.db.mysql.windows |
|---|---|
| Message-ID | <[email protected]> |
One thing this article mentions is accessing the SharePoint database through SQL queries from other (non-SharePoint applications). Directly accessing the database will promptly result in a non-supported scenario by Microsoft. Randall Price VT.SETI.IAD.MIG:Microsoft Implementation Group " http://vtmig.vt.edu + [email protected] ' (540) 231-4396 -----Original Message----- From: [email protected] [mailto:[email protected]] Sent: Monday, January 23, 2006 9:38 AM To: Chris Van Reenen Cc: [email protected] Subject: Re: Question "Chris Van Reenen" <[email protected]> wrote on 01/19/2006 11:02:26 AM: > Hi. > > > > I want to find out if MySQL can be used in place of MS SQL? > > But I want to find out if I can get SharePoint working on MySQL with out > any limitations. > > I was given the task to see if there is any other DB that we can run > share point on. > > I don't want to try for months and then find out that it can't be done. > > So if you guys can just give me a answer on this, it will be great. > > Thanks for your help and keep the good work going.. > > Regards > > Chris > > > How much control do you have over how SharePoint interacts with the database. I ask because MySQL can appear very nearly like an MS SQL server but never exactly. If you obscure your data link through an abstraction layer (like ODBC) your odds of compatibility increase. Based on what I read here: http://www.codeproject.com/cs/database/Sharepoint_Database.asp It seems as though SharePoint has been designed specifically towards the features of the MS SQL server (or MSDE). So long as it doesn't require any functionality not provided by MySQL (like table variables or any other MS SQL-specific features) your chances of success improve again. However, I suspect that SharePoint is compiled with the OLE DB for SQL Server as it's only form of database connectivity so the ability to actually repoint it to a MySQL server may not exist. Shawn Green Database Administrator Unimin Corporation - Spruce Pine -- MySQL Windows Mailing List For list archives: http://lists.mysql.com/win32 To unsubscribe: http://lists.mysql.com/[email protected]