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