[dba-SQLServer]Re: Access to MySQL

Hello Robert,

I have never used MySQL, but I am gobsmacked,

Only last night I had a discussion with my brother about the benefits to a
developer if he could develop in MySQL also.  However, if it does not
support Ref Integrity and does not support Sproc's (at the moment, I saw the
note about Version 5), then I think that this is a db I would not consider,

also, if it currently has these limitations, I have to wonder what other
limitations it has,

I think that I am back to MSDE for the moment,

Is Firebird much better than MySQL, I have never heard of it?

Thanks for the info,

Mark


----- Original Message ----- 
From: "Robert L. Stewart" <rl_stewart at highstream.net>
To: <dba-sqlserver at databaseadvisors.com>
Sent: Monday, November 10, 2003 6:54 PM
Subject: [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
>
>
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
>
>