I signed up to BizSpark, and they accepted my application. I feel that hosting the website on Azure is a no-brainer, I mean free scalable cloud hosting, I'd be nuts to turn that down. However the database is what I'm pondering.
The website revolves around a MySQL database, however even though Azure offers MySQL should I consider switching to a SQL Server database? I feel that Microsoft giving me free access to these services, I'm obliged to use their products.
No matter which path I chose I'll have to restructure the database. I was in a rush designing it (three days before going live, school told me something they forgot and had to do a rewrite) and there are a lot of things I want to improve (foreign keys, remove the comma-delimited fields, etc.).
But should I stick with MySQL, which I know well and have used before, or move over to SQL Server for the sake of hosting the website on Azure?
- Written in ColdFusion (requirement by the school) but porting the code to PHP
- MySQL database
- Only two rival products in New Zealand that are competing with me.