Results 1 to 5 of 5
  1. #1
    Join Date
    Feb 2005

    Unanswered: MSDE worth using or should I invest in mySQL? (was "MSDE")

    I'm not sure if this is the correct forum for this this question but I'll give it a shot.

    The only db development that I have ever done is in MS Access. I have a project at work that is being accomplished in VB and I need a db engine to use as the back end. Visual studio came with a copy of MSDE. Is this tool worth using or should I invest in mySQL? Are there any advantages to using MSDE over mySQL?

  2. #2
    Join Date
    Feb 2004
    In front of the computer
    Provided Answers: 54
    In my opinion, MSDE blows MySQL away. MSDE is a "scaled down" version of SQL Server. From a SQL syntax perspective, it is nearly impossible to tell them apart (yes, the purist can find functions designed to tell you the difference, but there are no meaningful differences to me).

    I'd strongly recommend MSDE over MySQL in almost every case, for many reasons.


  3. #3
    Join Date
    Nov 2002
    Or SQL Server Express if you can wait awhile

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  4. #4
    Join Date
    Apr 2004
    Kansas City, MO
    It really depends what you're using it for. If you are on a Windows based platform, then use MSDE. If not, then use mySQL. If you want data integrity, then use MSDE. If you don't care and you're just a developer, then use mySQL. There are a couple other differences of course.
    When life gives you a lemon, fire the DBA.

  5. #5
    Join Date
    Feb 2005
    Omaha, NE
    Quote Originally Posted by Brett Kaiser
    Or SQL Server Express if you can wait awhile
    Or Sybase ASE Express, which you don't have to wait for

Posting Permissions

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