MSSQL or MySQL?

[loon]

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.

*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.


From www.webhostforasp.net

[sb225]

Re: MSSQL or MySQL?

yes mysql i like it because it was easy to code

[cy4nide]

Re: MSSQL or MySQL?

personally i have always used MySQL, more flexible and easier to use, understand and apply... i have heard of MsSQL though

[cocaine]

Re: MSSQL or MySQL?

I've never used mssql.
I was thinking mysql and mysql are same hehe.

[webspider2005]

Re: MSSQL or MySQL?

I have been using MYSQL because of its partnership with PHP. These two open source applications gave dynamism to websites . So far MYSQL has proven itself as a stable SQL applciation in tandem with PHP.

[LikuiD]

Re: MSSQL or MySQL?

Never tried using MsSQL before, and I see no reason to
MySQL is really very easy to master, and it has all the functions one would need to create an easy and efficient database..

[AugustineCruze]

Re: MSSQL or MySQL?

I usually like MySQL rather than MS SQL. Bcoz mysql is easy for me and i am using it since years passed and abt MSSQL i've used it few times.. and not for any important jobs. And there is little different in between this two.

[Floryn]

Re: MSSQL or MySQL?

i only use mysql, to be honest i never heard og mssql until now, but i`m not that mutch in programing/database

[james0131]

MySQL is best one for us we are have all Linux server which provide good help