MySQL or MS SQL Server?

[Mafarazzo]

Anyone knows what database is better to run with Coldfusion MX 7(MySQL or Microsft SQL Server)? I'm working on a new website and I have to make a decision fast.

[Kronin555]

Depends on a number of things:

Are you going to be administering it? What's your knowledge level? Are you
more comfortable with one over the other? Do you have funds budgeted to
purchase a database server? Is the site going to be hosted somewhere? What
database(s) do they support? What databases have you used in the past?

[jorgepino]

Price Setup time
My sql $Free 10 hours
MSsql $4000 2 hours

[mxstu]

Like Kronin555 said, there are a number of factors that affect your decision.
A lot depends on your needs, enviroment and experience, etc. Although I know
my preference, I wouldn't blindly say that one database is always preferable
over the other ... or that one would necessarily be suitable for every
situation.

[Mafarazzo]

Hi Kronin555. A few answers:

No, I dont have access to the database server or its configurations. I'm
paying for a hosting service which offers me MySQL, MS Access or MS SQL. I'm
used to work with MS Access for small applications, and Oracle for business.
This time, it's a personal website. I haven't worked with MySQL or MS SQL
before, so they are the same to me. The price of the hosting service is the
same, not depending on the database I decide to use.

Any extra help? Thank you in advance.

[Kronin555]

Do you know which version of MySQL they have? Older versions don't support certain things, like subselects.

[Mafarazzo]

The versions are:
MySQL 4.1.14, Microsoft SQL
Server 2000 SP4

I just knew that I will have access to the database server, through MS SQL Server manager. Not sure about MySQL.

[Kronin555]

That version of MySQL is as new as you're going to get without going to a beta release.

Do they provide phpMyAdmin for MySQL? It's a web interface to manage your databases.

[Kronin555]

That version of MySQL is as new as you're going to get without going to a beta release.

Do they provide phpMyAdmin for MySQL? It's a web interface to manage your databases.

[ShytKicker]

Basically you can split down two roads. First ask yourself, is this for an
enterprise application or a personal/standard application?

a. Enterprise: Sql Server
b. Standard/Private: MySQL

MySQL 5.0 is in beta as of right now, but will be a production version by
October/November. MySQL 5.0 introduces many things that Sql Server can do, so
it brings it a few steps closer to use with enterprise applications. MySQL 5.0
has stored procedures, stored functions, triggers, and other goodies that
really make a difference. The Archive engines/Federated engines, and alot more.

MySQL 5.0 is in beta, meaning it is really close to a bug-free, if not
completely bug-free version. If the beta passes x months without a major bug,
it is then turned into a Production version, and that is what seems to be
happening right now.

MySQL is also faster, and the storage engines really make it an interesting
database to use. Although be sure to use ODBC or C native driver when using
with cf, don't use JDBC unless you have to.

I must say either take MySQL 5.0 Beta or wait for production version. Take SQL
Server if you do not want a beta version.

[BKBK]

>... MySQL is also faster... Although be sure to use ODBC or C native driver when using with cf,

>... don't use JDBC unless you have to.

Why ODBC or a C-native driver, but not JDBC?