[dba-SQLServer]Re: Access to MySQL

You can also include PostgreSQL in your investigation.

> -----Original Message-----
> From: Mark L. Breen [mailto:subs1847 at solution-providers.ie]
> Sent: Wednesday, November 12, 2003 1:39 AM
> To: dba-sqlserver at databaseadvisors.com
> Subject: Re: [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
> >
> >
> 
> 
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
> 






This transmittal may contain confidential information intended solely for
the addressee. If you are not the intended recipient, you are hereby
notified that you have received this transmittal in error; any review,
dissemination, distribution or copying of this transmittal is strictly
prohibited. If you have received this communication in error, please notify
us immediately by reply or by telephone (collect at 907-564-1000) and ask to
speak with the message sender. In addition, please immediately delete this
message and all attachments. Thank you. ACS12/11/2003