MSSQL or MySQL? - Host Discussion Blog

dicky · 11-15-2006, 01:27 AM

Microsoft SQL Server 2005 database engine was a favour of many web developers due to its ability in providing more secure, reliable storage for both relational and structured data. It enabling developers to build and manage highly available, performant data applications that developers can use to take their business to the next level. In fact, a lot of analysis also showed that MSSQL Server is better compared to other database system such as DB2, MySQL, PostgreSQL, etc. However, MSSQL Server is also been categorised by many developers as a very expensive database management system to use, even until now. Due to this, a lot of developers started to shift from MSSQL server to cheaper or free database system.

When comparing linux server and windows server, people tend to relate linux server with mysql and windows server with mssql. Linux server become the preference of many developers because it is cheap, mysql is free. Windows servers with mssql is very expensive.

Now, Microsoft has come out with a new product, MSSQL Express. Microsoft SQL Server 2005 Express Edition (SQL Server Express) is a powerful and reliable data management product that delivers rich features, data protection, and performance for embedded application clients, light Web applications, and local data stores. SQL Server Express is available at no cost, easy to use, redistributable version of SQL Server 2005 designed for building simple data-driven applications. Developers can design schemas, add data, and query local databases, all inside the Visual Studio 2005 environment. Furthermore, if developers need more advanced database features, then SQL Server Express can be seamlessly upgraded to more sophisticated versions of SQL Server.

MSSQL Server 2005 Express Edition is been designed in such a way that it remains good features from MSSQL Server 2005 while in the same time benefited developers by giving it out for free. SQL Server 2005 Express Edition is easy to install; easy to use and manage; rich with database functionality; better security; simple pricing and licensing; with xml support; deep integration with Visual Studio 2005; better scalability and performance; etc. Please visit http://www.microsoft.com/sql/edition.../features.mspx for more information.

Database system is now considered as a critical factor in choosing a web hosting providers and MSSQL Express is simply the best choice, good yet cheap.

Dbreh · 11-16-2006, 08:03 AM

Most personal website get used to MySQL , and it's your choice

paula · 11-20-2006, 11:25 PM

Hi Dicky,

Most of the hosting services provider go for mysql + Linux for the best results but you can always choose the best one that suits your requirements.

kollins77 · 11-25-2006, 05:22 AM

It's up to you to dacide what to choose. I like MySQL.

dicky · 12-15-2006, 02:45 AM

how about in term of performance?
is mysql better compare mssql express?

paula · 12-20-2006, 05:32 AM

Hi,

Mysql is best than Ms sql. The bug fixing is easy in mysql.

alemcherry · 01-14-2007, 11:12 AM

Quote:

Originally Posted by paula

Hi,

Mysql is best than Ms sql. The bug fixing is easy in mysql.

MSSQL has got a number of enterprice features than mysql. There is no comaprison when it comes to features. MSSQL is more like oracle where mysql is more like MSAccess

If you need transactions, stored procedures, triggers, views, indexed views etc.. SQL server is the choice.

But mysql is fast, free and lite. For 95% of web applications, mysql will be enough. If you are creating serious applications where data is critical, sql server is obviously a better choice.

shakir · 12-05-2007, 11:55 AM

for small websites and applications my sql is best , but if go for good portal and big applications and sites better MSSQL which have many features. Cant compare MYSQL with MSSQL. bcz MSSQL is wat and strong , mysql is nothing but small.......