What are Pros and Cons of using MySQL/Access

[Tomadams]

I am just learning about MySQL. Can someone give me a boost up the learning curve. What are the pros and cons of using MySQL with an access ftont end. How does it compare with using SQLServer?

Thanks,
Tom

 

[sleipnir214]

MySQL and SQL Server are both relational database servers. They have comparable core functionality in the use of SQL queries to manipulate data. They differ in some of the additional functionality -- MySQL does not yet support an internal programming language, views, stored procedures. I say "yet", because a lot of this functionality is coming in MySQL 5.0, which is not yet a production release.

The other difference, too, is cost. SQL Server will run you about $5000/processor plus an additional cost for each concurrent user. MySQL is available as GPL software or as supported licensed software, but the license is significantly less expensive than SQL Server.


Want the best answers? Ask the best questions!

TANSTAAFL!!