January 1, 2005 at 7:32 am
I know I run the risk of being tarred and feathered with this crowd. But I'm wondering, what are the significant differences between MySQL and SQL server 2k? Could PHP code be written against SQL server 2k? Just consider me a poor, misguided soul!
SMK
January 1, 2005 at 11:29 am
You will find that even though this site is dedicated to SQL Server, its members work and play in the real world that includes many database systems.
I haven't used MySQL or PHP, but it looks like there are some articles on this site addressing your questions.
http://www.sqlservercentral.com/columnists/dpoole/alookatmysql.asp
Also see http://php.planetmirror.com/manual/en/ref.mssql.php
I'm not sure if you are experienced in MS SQL wanting to move to MySQL or vice versa. Maybe if you elaborate a little bit on your question someone can give you more specifics.
Hope this helps,
Kathi
Aunt Kathi Data Platform MVP
Author of Expert T-SQL Window Functions
Simple-Talk Editor
January 1, 2005 at 1:33 pm
Thanks, Kathi.
Very helpful links. I have a MS SQL DB and I was wondering if PHP programmers could access and program against it. It looks like they can.
Have a great New Year!
SMK
January 2, 2005 at 11:23 am
I like the idea of MySQL. I think PostgreSQL is a better product, more mature, but advances occur rapidly in both products, so that might not be the case. I haven't looked at MySQL in a few years and at that time it was a capable db for many needs, but lacked a few things that I think are imoprtatnt, like stored procedures, subselects, and trancsactions. I know transactions can be added in and subselects are supposed to be a part of the newer versions.
In many cases, all of the major databases (MSSQL, Oracle, DB2, Informix, MyQSL Postgres) will do the job. However they have their strengths and weaknesses. I like MSSQL on the windows plaform. It's relatively inexpensive, it's got a very complete features set, and scales well. That's personal preference however. If I were doing something for home use and cost is a factor, I'd have to compare MSDE with MyQSL and decide. The important factor would really be time. I don't have MySQL skills and if I was in a hurry, I'd stick with what I know. I'd recommend the same for a business. If you have MSSQL people, doesn't make sense to save a few thousand to implement MySQL. If you have MySQL skills, doesn't make sense probably to pick MSSQL.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply