The SitePoint Forums have moved.

You can now find them here.
This forum is now closed to new posts, but you can browse existing content.
You can find out more information about the move and how to open a new account (if necessary) here.
If you get stuck you can get support by emailing forums@sitepoint.com

If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

mySql vs MS SQL

I have a software which uses MS SQL and ASP .NET. We are looking at catering the LINUX audience as well. Can some one suggest me a good article which can list me out the major drawback (feature availability) of MySQL over MS SQL.

I have a software which uses MS SQL and ASP .NET. We are looking at catering the LINUX audience as well. Can some one suggest me a good article which can list me out the major drawback (feature availability) of MySQL over MS SQL.

Also, can I do a BULK INSERT in MySQL and have SubQueries?

I'm not worried about performance at this point of time.

Ideas please.

Thank you,
Shalin Jain

If you already have MSSQL and your software is written in .NET, then stay with MSSQL. It will make your life much easier.

The main drawback of MySQL is a lack of stored procedures, if you use them. I believe support for subqueries has been added in the most recent versions of MySQL (4.0 or 4.1, I'm not sure).

A DBMS that supports T-SQL (although not all of the Microsoft extensions) is Sybase ASE. Porting your product to ASE should be relatively painless (provided again you don't use a ton of the MS SQL extensions) and enables you to run on Linux, Solaris, AIX, etc.