Database Choice for Web Applications

[gbullock]

Dear all,

I am currently undertaking an academic project to design & build a Web Application (using HTML5 and open standards) that will require a data storage method and a means of serving the data to the Web Application.

Data will include items such as simple statistics in numeric format and information in text format.

I am considering using SQL Server as the technology choice for the database, to be hosted online via a suitable web server and accessed by the web application's data API.

It is important that the data technology used is capable of providing data exports in standard formats (CSV etc.) and accepts data imports using standard methods (SQL script, Flat File Imports).

In order to assist me with making this choice, I would be very grateful if anyone who has experience of using SQL Server with Web Applications in this way could provide brief feedback, stating if you feel SQL Server is a suitable/reliable approach.

Thank you for your help with this.

Best wishes,

Greg

[Luuk]

At first you should specify the needs in more detail.

It is always a FALSE start to start with:
"Is SQL Server suitable for this job"

The answer may be yes, or no...

But how to i.e. MySQL compare to SQL Server for this job?

It might be the case that SQL Server can do the job, but than another database (like i.e. PostgreSQL, SQLite or MySQL) is a better choice......