[dba-SQLServer]Re: Access to MySQL

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