Question

------_=_NextPart_001_01C61D11.C06F0A9C
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

Hi.

=20

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.=20

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

=20


------_=_NextPart_001_01C61D11.C06F0A9C--

Re: Question

--=_alternative 00500571852570FF_=
Content-Type: text/plain; charset="US-ASCII"

"Chris Van Reenen" 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.a sp

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
--=_alternative 00500571852570FF_=--