[dba-SQLServer]Re: Access to MySQL

While this IS a SQLServer list, I think that allowing positive and 
accurate information about other data storage engines would be helpful.

I just visited mysql.com and comming in mySQL 5.0 is Stored Procedures 
and Triggers. so #2 will be crossed out in the following list, 
additionally according to the licensing scheme it goes like this

/quote/

The software from MySQL AB listed below is licensed under the GNU 
General Public License (GPL) 
<http://www.mysql.com/products/licensing.html> and is provided "as is" 
and is without any warranty.

You need to purchase commercial non-GPL MySQL licenses 
<https://order.mysql.com/>:

    * If you distribute MySQL Software with your non open source software,
    * If you want warranty from MySQL AB for the MySQL software,
    * If you want to support MySQL development.

/end quote/

It doesn't sound like they will be distributing anything, so option one 
does not apply.  If her company wants support from mySQL then they would 
pay license cost that way, otherwise then not. and of course there's the 
third option.




Robert L. Stewart wrote:

> Cindy,
>
> A few things that no one has mentioned.
>
> 1.  MySQL does not do foreign key constraints.  This means
> that you have to program relational integrity in the front
> end.
>
> 2.  MySQL does not do stored procedures.  This means you
> have to do all of the things you would normally do in a
> stored procedure in the front end also.
>
> 3.  MySQL is not free except in a development environment.
> The cost for a production environment is very reasonable,
> around $495 if I remember right.
>
> 4.  If you are running MySQL under NT, you have to stop the
> database services before shutting down or you will trash the
> install and have to reinstall MySQL.
>
> You might want to look at Firebird instead.  From what I have
> read about it, it can handle 1 and 2 above.
>
> Robert
>
>
> At 12:00 PM 11/8/2003 -0600, you wrote:
>
>> CYNTHIA SPELL wrote:
>>
>> >My organization is considering moving our backend databases to My 
>> SQL and continue using Access for our frontends.  Does anyone know of 
>> a good list I could subscribe to to get more information about My 
>> SQL?  I know we've had some discussion about this subject on this 
>> list, but I've searched the Archives and have not found a whole lot 
>> of information.
>> >
>> >Thanks.
>> >Cindy
>


-- 
-Francisco