MSSQL or MySQL?

D

dicky

New member
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/editions/express/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.

*Tips: Type "Free MSSQL Express hosting" or "MSSQL Express windows hosting" in google search to search for web hosting company that have MSSQL express ready in their control panel.
 
Hello,

thanks for sharing the information.

MSSQL is the most powerful database server which can store a large amount of data and a manipulate the same. MySQL server does not have that much capacity to hold data.

Thank you.

Regards,
 
hostechsupport said:
MSSQL is the most powerful database server which can store a large amount of data and a manipulate the same. MySQL server does not have that much capacity to hold data.
Click to expand...

Could you please elaborate on what you mean by this?

MSSQL Express edition supports only 1 CPU, 1GB of Memory, and a 4GB maximum database size. That is why it is free. MySQL has no such limitations.
 
I would like to point out something very important when it comes to mssql, besides the ridiculous pricing...It's proprietary. MySQL is not only free, but extremely cross platform compatible. In fact, in many cases MsSql is even more cross platform compatible.
 
ANMMark said:
I would like to point out something very important when it comes to mssql, besides the ridiculous pricing...It's proprietary. MySQL is not only free, but extremely cross platform compatible. In fact, in many cases MsSql is even more cross platform compatible.
Click to expand...

yes true and we are refering to MSSQL express which is free
 
I myself like MySQL, and it seems to be a pretty powerful database. Other than that my only other experience is with Oracle, which is an awesome database if you have large amounts of data (we use this at my work place.)

However, what I have really liked about MySql is that its free! :thumbsup: Does anyone know how much data a MySql database will hold before it starts to get sluggish? And does MSsql express have the ability to store more data?

I may have to give it a try since it is available for free.
 
Last edited:
I think, MySql is a great solution and the MAJOR BENEFIT is its free... we can find a lot of developers for Mysql in compare to MS Sql.
 
You must log in or register to reply here.

Supporters

Back
Top