SitePoint Sponsor

User Tag List

Results 1 to 7 of 7

Thread: mySql vs MS SQL

  1. #1
    SitePoint Addict Shalin's Avatar
    Join Date
    Sep 2003
    Location
    __beyond
    Posts
    295
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    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.

    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
    Help Desk Software - Helpdesk Pilot
    Flash Screensaver - Screenswift for Windows
    Online Polls - Tezaa.com
    Address Book Software - Addza for Windows

  2. #2
    ☆★☆★ silver trophy vgarcia's Avatar
    Join Date
    Jan 2002
    Location
    in transition
    Posts
    21,235
    Mentioned
    1 Post(s)
    Tagged
    1 Thread(s)
    Quote Originally Posted by Shalin
    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).

  3. #3
    SitePoint Addict Shalin's Avatar
    Join Date
    Sep 2003
    Location
    __beyond
    Posts
    295
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Okay few questions:
    1. MSSQL can be installed on LINUX?
    2. Is there ASP .NET framework available for LINUX (just to confirm)?
    Help Desk Software - Helpdesk Pilot
    Flash Screensaver - Screenswift for Windows
    Online Polls - Tezaa.com
    Address Book Software - Addza for Windows

  4. #4
    SitePoint Wizard bbolte's Avatar
    Join Date
    Nov 2001
    Location
    The Central Plains
    Posts
    3,304
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

  5. #5
    SitePoint Addict Shalin's Avatar
    Join Date
    Sep 2003
    Location
    __beyond
    Posts
    295
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    thanks!
    Help Desk Software - Helpdesk Pilot
    Flash Screensaver - Screenswift for Windows
    Online Polls - Tezaa.com
    Address Book Software - Addza for Windows

  6. #6
    Database Jedi MattR's Avatar
    Join Date
    Jan 2001
    Location
    buried in the database shell (Washington, DC)
    Posts
    1,107
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    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.

  7. #7
    SitePoint Addict Shalin's Avatar
    Join Date
    Sep 2003
    Location
    __beyond
    Posts
    295
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    great. thats a good idea! I'll find out more about ASE.

    Thanks!

    Cheers,
    Shalin
    Help Desk Software - Helpdesk Pilot
    Flash Screensaver - Screenswift for Windows
    Online Polls - Tezaa.com
    Address Book Software - Addza for Windows


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •