Besides the fact that it is free, is a start-up going to miss having several features that proprietary databases like SQL server or Oracle have in them?
2006-08-06 17:54:35 · 4 answers · asked by xdwcpsd 3 in Computers & Internet ➔ Programming & Design
I use SQL server on half my projects and mySQL on half my projects. If you have the money I would suggest SQL server as it has a few extra features you may be looking for and a nicer (in my opinion) interface to the db for setting up dbs/tables, creating jobs, backups/restores, and data transfer. A major drawback for mySQL up until recently was the inability to create views, stored procedures, nested queries and have XML features. I believe the first two have been addressed in the new version (I am still using ver 4 on most of my projects). SQL server has pretty good built in XML commands to return data in XML format. It also has great data transfomation packages you can create if your application needs to regularly import or export large amounts of data from various sources. If you don't need some of these 'extra' features I would say mySQL is a good choice. I have never ran into any performance or reliability issues with it, is just doesn't have as many featues as SQL server (which may be OK if you don't need them). The new version of mySQL now comes with a great admin and query program to manage the db in a more visual way which is a huge plus over previous versions.
Also, remember you aren't tied to Windows for your hosting environment with mySQL which may be cost issue if you grow in the future.
I would steer clear of Oracle. It is very expensive and hard to learn/setup. I have migrated several clients from that to SQL and mySQL since they didn't have the resources to properly manage the db. I can't think of anything that Oracle offers that you can't accomplish with SQL server.
2006-08-07 04:24:31 · answer #1 · answered by jmfc 4 · 1⤊ 0⤋
for a start up, mysql will do just fine.
personally, i feel that oracle is over-rated, and i've never touched SQL server. just hire someone who knows what they are doing.
a lot goes into database design :)
2006-08-06 17:59:09 · answer #2 · answered by duct_tape_is_good 4 · 0⤊ 0⤋
MySQL, like much open source code, comes with free advice. I find it much easier to find advice on message boards about MySQL then in Microsoft Developers Area.
2006-08-06 18:12:42 · answer #3 · answered by LorettoBoy 4 · 0⤊ 0⤋
all I want to tell you is that Google uses MySQL for their large AdWords Database.
Now make the choice for yourself.
2006-08-06 18:09:07 · answer #4 · answered by iammisc 5 · 0⤊ 0⤋