SQL VS MySQL

[dreamdelerium]

hey everyone. another db question. ive been trying to install SQL server express on my computer but im having all kinds of problems. i was thinking about just using MySQL (as i have experience with it with PHP). how comperable is it to SQL server. what are the pittfalls of using it? like i said in an earlier post, i want to create an application that runs on local machines, stores data in DB's located on servers, and can connect to a centralized server located off site via the internet

thanks
jason

 

[MattP]

SQL Server vs MySQL

Article is comparing SQL Server 2000 to MySQL 4.1 but the overall jist of the argument holds for newer versions. The dealbreaker for me (besides being in a SQL Server shop) is the dialect table in the article.

 

[cjard]

I always found the amount of time it takes to (write code as good as the dataset designer does)/(port dataset designer code) for MySQL made it completely not worth the bother. Just my 0.02, but I really like it when a db can be integrated with my IDE. Oracle and SQLServer get this.. other offerings.. just dont do so well