Skip to main content
Participant
January 13, 2007
Question

mssql or mysql?

  • January 13, 2007
  • 3 replies
  • 575 views
Brand new to coldfusion and any type of sql.

Mssql or Mysql??

Which version of sql should I use for what I am trying to do? Can you tell me the differences if any between the two? Cost? Function? Capabilities? Compatability?

I plan on having a couple of different websites for different companies (home based businesses). My intention is to have each site I create have user specific logins, training information, etc.

One of the websites will eventually be used for commerce, have items for sale, etc.

Thanks in advance for the help.
This topic has been closed for replies.

3 replies

Inspiring
January 14, 2007
No, not 'everyone' uses mysql - otherwise there wouldn't be a product such
as MSSQL Server - would there?

In answering the OP's questions - there are quite a few
advantages/disadvantages of each - and in all honesty - stating one is crap,
is not really a good reason.
So, for the OP - mysql is for the general use of us all - free. There is
also a community version, which is paid, which entitles you to support of
some degree. Most hosts will offer one or other, depending on what types of
servers they are running - typically linux will have mysql, and windows
servers would go for MSSQL server. This isn't a had fast rule, as my current
server is windows and mysql - which I find great!

JFuentes12 - it really depends on what you want to use, and what your host
has installed, more than anything. Both flavours of SQL will require some
learning of the server operations (in small degree) and when you get complex
in your queries, there are platform specific commands you will write when
using SQL. The choice is yours.

Brendon


"Hugh Neale" <webforumsuser@macromedia.com> wrote in message
news:eodkvo$i1t$1@forums.macromedia.com...
> mySQL msSQL is microsoft.... and everybody uses mySQL microsoft are crap.
> :)


January 14, 2007
mySQL msSQL is microsoft.... and everybody uses mySQL microsoft are crap. :)
Inspiring
January 13, 2007
Shop around for hosts and pick a couple that you are most likely to use. Then see what they support.
Participant
January 14, 2007
Thank you for the quick reply. I am using webhost4life.com and apparently they support both choices of mysql or mssql.

Which would bring me back to my original question.... Mysql or Mssql.... What are the pros and cons? What is easier to use"? Which costs more? Are there any compatability issues to consider? Anything regarding functionality?

Which should I use?

I plan on having a couple of different websites for different companies (home based businesses). My intention is to have each site I create have user specific logins, training information, etc.

One of the websites will eventually be used for commerce, have items for sale, etc.

Thanks in advance for the help.