Hello,
I have developed a web application that uses the built in membership and roles functionality for MS sql server. I have experience in both mysql and ms sql so converting my current code from ms sql to mysql is no problem. So would you recommend mysql on a windows box?

It works fine on Windows. You won't get the obvious MS SQL server advantages such as windows authentication integration but I'm assuming you already know that.

I have developed a number of applications on windows boxes and have never had any problems with MySQL.

I wouldn't recommend using mySQL over msSQL when building a web app in ASP.NET. It can be done...but I don't see the point of coverting your code to MySQL.

I wouldnt really agree that its bad for it.

MSSQL definatly goes better however this is where the power of ASP.NET comes with.

Depending on the complexity, you should be practicing the 3 tier system.

You have DAL (data access) BLL (business logic) UI (user interface).

So what you can do is create two DALS (one for MSSQL and one was MySQL).

my main reason for switching to mysql is the cost. Its a whole lot cheaper to run mysql then it is for ms sql. it costs $2000 per month to run the full version of ms sql. so you know where im going with this.

Well, if cost is a problem, and you think you have the ability to switch over to MySQL w/o it affecting your original .NET functionality then I don't see why you wouldn't switch.

The only concern I would have is how difficult it would be to migrate the membership tables. I've used SQL server and MDF but never MySql. If you can tackle that, then I don't see why you would have any difficulty using MySql.

Ideally you should be able to regenerate your membership schema by copying it from mssql to mysql. Depending on your application, you may not need the full blown mssql server and the free edition might work for you as well.

There are programs that are designed for such tasks (ie, server migration).

the free edition might work for you as well.


Burhan, when you say "free edition" are you talking about the developer version of ms sql or express? I thought the free version was just for development, and was severely limited with regards to accessibility?

I mean the express edition. Believe it or not, there are 6 editions of sql server; you can compare them all here (http://msdn.microsoft.com/en-us/library/ms143761.aspx).

However, the important bits for SQL Server Express:

4 GB DB Limit
1 GB RAM Limit
1 Processor Unit Limit

I mean the express edition. Believe it or not, there are 6 editions of sql server; you can compare them all here (http://msdn.microsoft.com/en-us/library/ms143761.aspx).


Thanks Burhan. Not only was that educational, it was entertaining too!

I need to go figure out what these different versions are, then take a couple aspirin for the headache it's going to cause :)

Ideally you should be able to regenerate your membership schema by copying it from mssql to mysql. Depending on your application, you may not need the full blown mssql server and the free edition might work for you as well.

There are programs that are designed for such tasks (ie, server migration).

I am not entirely sure but does mySQL have support for sprocs?

I am not entirely sure but does mySQL have support for sprocs?

It does have support for stored procedures.

MySQL 5.0+ adds support for stored procedures and views.

Mysql runs very good in windows.Even you can use the admin interface to make changes in the settings.Mysql enterprise edition holds all features for a RDBMS.More details you can fetch from mysql site

I haven't done much with MySql, but what little I've experimented with it's been very easy to work with.

I have a family site that has a wordpress blog installed. I didn't want to use wordpress as the homepage but I wanted the most recent posts and comments on my homepage. It's written in classic Asp and the code changes were very minimal to get it to ready the wordpress mysql database.

mssql express edition has a limit on the database size. However it is useful to run mid sized databases and provides more or less the same level of functionality as the lowest paid version gives

Or you can use Oracle Express. It has similar limits as the MsSQL express version.

There is also Derby (http://db.apache.org/derby).