I created a web application that is heavily database dependant. It is a complex application and every page is dynamically generated by the DB. The original intent was for this application to run MS sql for its backend. However due to ms sql licensing costs I think I may need to change to a less expensive solution such as MySQL.
Just to be clear, I want to go live with this web application with my own servers but Im having second thoughts if i should stick with MS SQL.
Here are the options:
-MSDE/sql_serverExpress FREE but database limit of 2/4 GB, and you can only use serverExpress with 1 processor.
So if you're using a dual processor server, you are out of luck. Also, we have to think of the future here and plan for having a DB greater than the 2/4 GB size. If we exceed this size we have to move on to MS SQL Standard edition.
-MS SQL Standard $4,999 per processor. So if the application is doing well and we have 4 processors running our DB then the cost is 20,000$ USD
OK assume that the site is succesful and your startup can manage to pay this amount.
SQL standard has a 4 processor limit. So if you go beyond 4 processors you will need to get MS SQL proffesional
-MS SQL Professional $19,999 per processor. So if you have 5 procs you are now paying $120,000.
Source for prices: [microsoft.com...]
Ofcourse in order to need 5 processors running your DB your site must be doing pretty well. But still, It just doesnt seem like MS SQL scales financially.
I would like the opinion of others.
q1)am I overestimating the costs. That is, can these software be found usually at much discounted prices?
q2) are ms sql licenses transferable. that is can I sell my license to someone else?
Q3)If you were in chage of a web application that you thought could become very popular would you use MS SQL? or would the expenses turn you to a less expensive solution such as MySQL.
Q4)Also what are the drawbacks of using MySQL?
Thanks for any insight.