mysql and ms sql databases

Hey guys! Could you please explain the difference between mysql and ms sql database technologies. When it is better to use each of them?The ppoint is that I have some experience of work with mysql(I created databases and tables using phpmyadmin) however I have never been connected with ms sql databases. That's why I am asking this question. Are there any signifficant differences?

 

mySQL is used more for Linux servers while MS SQL is used more for Windows servers.

 

Search on Google for comparison and you will find a lot of resources on this e.g.
http://www.mysql.com/news-and-events/on-demand-webinars/display-od-69.html
http://www.mssqlcity.com/Articles/Compare/sql_server_vs_mysql.htm

 

If you have experience of mysql then imho, you should stick with it.

 

You find this article helpful: http://www.tometasoftware.com/mysql_vs_sqlserver.asp. And this one too.

 

mysql free open source / mssql you have to pay only for windows
but the same they are "structure query language" . they have some same/similar command.

 

If you're concern over speed, MYSQL is the way. It works faster than MS SQL.

 

Also, you can use MySQL to open source programming like Java. MSSQL is too exclusive for Microsoft You can have difficulties in configuring some of your commands.

 

Who said you that?

If MySQL was the best out there, no one would use MS SQL/Oracle, etc. It just depends on the site and your goals. Although, I use MySQL as Im more familiar with it

 

the major differencies are scaling and official support. MS SQL is enterprise-level product. You pay for it so you get the according support. MySQL is known to be not so suitable for huge databases.

Language is nearly the same, but MS SQL is a more sophisticated platform.

 

MySQL 5 supports both
http://dev.mysql.com/doc/refman/5.0/en/triggers.html
http://dev.mysql.com/doc/mysql/en/stored-procedures.html

 

MS SQL is technically better/more scalable/etc. than MySQL. but if you're into LAMP development, go with MySQL. if you're a MS shop go with SQL Server.

 

I would agree with the posts in this thread, however if you have used mysql I think you would be able to use mssql without too much of a learning curve if for some reason you decide to use it over mysql

 

One thing to consider if you are a microsoft fan is SQL Server Express. It's free and has a lot of the same functionality as SQL Server.