MSSQL or MySQL?

Nokia · Site Admin Joined: 08 Nov 2003 Posts: 18573

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.

NOTE: I still love MySQL on Linux Laughing

Guttu · Posted: Thu Nov 30, 2006 3:03 pm Post subject:

MYSQL zindabad!!
Will try that MSSQL in free time. But it'll take some time to get used. As I'm just now getting used to MYSQL

ceptic · BizHat Newbie Joined: 12 Dec 2006 Posts: 6

i created my mysql script it took me like 3weeks (cos i was a noob bak then and didnt no how to code properly)

kalamar · BizHat Newbie Joined: 01 Jan 2007 Posts: 6

i think mysql... it's more usefull then mssql...

Nokia · Site Admin Joined: 08 Nov 2003 Posts: 18573

Today i installed MS SQL 2005 express. Since MS provide express version free, we will see lot of people start using MS SQL for web site and applications. Good move by microsoft for making more money with more market Very Happy

xyclone · BizHat Newbie Joined: 26 Jan 2007 Posts: 7

is MS SQL 2005 express free forever?

Nokia · Site Admin Joined: 08 Nov 2003 Posts: 18573

Yes, it is free. You don't have to pay for using it.

xyclone · BizHat Newbie Joined: 26 Jan 2007 Posts: 7

cool... ill start working with MS SQL 2005 express.. tnx nokia..

laroussi · BizHat Newbie Joined: 14 Feb 2007 Posts: 5

Hi ,

Is the Ms mysql express the latest version ?

laroussi · BizHat Newbie Joined: 14 Feb 2007 Posts: 5

Hi ,

Is the Ms mysql express the latest version ? We are now in 2007 .

Thanks

djsprods · BizHat Newbie Joined: 22 Feb 2007 Posts: 12

well i use my sql, i aint used ms sql yet bt might do in the near future bt i just made a php code to install a lot of mysql tables and insert it automatically n that took a long time to understand etc so i might stay with mysql for the time lol

Taupe · BizHat Newbie Joined: 23 Mar 2005 Posts: 45

This post is completely stupid Wink

Everybody knows that MySQL and PostgreSQL are far superior than MSSQL. And it's not a matter of price (since people pay for MySQL non-free licence for instance)
More over, MSSQL is still closed source, that means more bugs and security issues, and less features developped...

So this M$ try won't change nothing : developers are not stupid...

aaron543 · BizHat Newbie Joined: 30 Mar 2007 Posts: 9

onselder · BizHat Newbie Joined: 16 May 2007 Posts: 8

teşekkürler arkadaşlar

kunlanit · BizHat Newbie Joined: 03 Jul 2007 Posts: 9

i use mssql for learning because it graphic user interface is fraindly =education

when use in business use mysql because it free and light cpu loading = business