SQL Vs mySQL

[slackologist]

Anyone found the need to migrate from mySQL to SQL? or prefer one over the other?

[twan]

I'm afraid i don't understand what you mean. SQL is a query language which mysql uses. It's inlogic to migrate from a database to a query language.

Do you mean postgresql or msql?

[Yahook]

Hello slackologist,

SQL is a language to make queries to databases. MySQL is a database. May be you mean to migrate from MySQL to another database, for example MS SQL?

[Lester]

Or are you asking about the Microsoft database product versus MySQL ?

(sorta what was just said..... )
opps, gotta pay attention in class!

[slackologist]

sorry guys, i'm meaning MS SQL Server Vs mySQL

[Yahook]

PHP+MySQL is FREE, for ASP+MSSQL you have to pay.

[Lester]

I think maybe the question is perhaps does there come a time when you "outgrow" MySQL and need MS SQL ????

and if so who has and why and how did it go to whatever you went to..

[anocow]

First of all, I think this thread needs a little correction : ASP + MSSQL doesn't have to cost you a penny. ASP is part of the Windows operating system and is preinstalled on all windows hosting plans.
There is also a free version of SQL server called MSDE it's a scaled down version of SQL server, missing the internal mail system and SQL scheduled jobs.
MSDE is to be replaces by a new product called SQL server Express, also a scaled down product, read about its features here : http://lab.msdn.microsoft.com/express/sql/ it is soon to be released & contains a lot of features, also a free product.
It's time that adult webmasters begin to look at MS platform as a viable building block for your business, of course the upper scaled products cost a lot, but most sites won't need them.

To answer your original question : a lot of the features of MS SQL server are neat, but not really needed in most app's, I think it boils down to whether or not youre a MS guy or prefer linux + linux app's, since :

performance : MySQL & MS SQL are both very well performing database servers.

features : MS SQL is a clear winner IMO, even the scaled down version has more bells & whistles, but does your app really need them? the TSQL dialect eliminates alot of PHP code when compared to MySQL, but so does a good DB design - hint!

cost : MySQL is free, so is MS SQL Express, although Express is a scaled down version it will fit most need's in any application, including heavy traffic websites.

security : they both had security issues, but all networked applications do!
In the hands of a competent administrator they are both very secure.

So to sum it up, if you currently use MySQL on linux & your app works, dont change, if you plan on migrating to windows - consider changing, however MySQL runs great on win too. if you plan on staying on linux but think MySQL lacks more advanced features - look into PostGreSQL it's pretty amazing!!! lot's of features & well performing.

[fireorange]

MS SQL? No thanks.
MS server? No thanks.

Tell me a sponsor that uses MS technology for their sites, I'm interested!

[anocow]

MS SQL? No thanks.
MS server? No thanks.

Tell me a sponsor that uses MS technology for their sites, I'm interested!

Good point!

I'm looking into buying a new ride... better mail my sponsor to hear what he's driving

[Yahook]

anocow, very good answer

[Lester]

Don't some sites use Microsoft Media Server extensively???
and if so I'm guessing thats a MS server only product...

I could be wrong here, so if I am, sorry....

[slackologist]

Thanks for the response guys.

I was looking at developing a site with either mySQL or MS SQL Server. I want to try and bridge our internal offline ordering and inventory system with a web interface and because i have little experience with either i was wondering what kind of limitations mySQL might contain and what kind of advantages either may offer.

I built a database today in MS SQL and have a cart system up which seems fairly robust, probably no different to anything done with mySQL but given my reservations about integration with other systems using mySQL, scalability etc i will leave it in the maybe not basket for now.