Post reply

Whats the difference between SQL Server 2000 Developer & MSDE

  • June 22, 2004 at 7:37 am

    #102074

    What's the difference between Microsoft SQL Server 2000 Developer & MSDE?

    Thanks!

  • June 22, 2004 at 8:07 am

    #511433

    In Simple, SQL Developer version has enterprise manager, query analyzer and all kind of development stuff..

    MSDE has only Service Manager to deal with! no enterprise manger or query analyzer.

    Linto

  • June 22, 2004 at 9:30 am

    #511454

    MSDE is poorly named (or acroynm'd). It is the Desktop Engine, basically a replacement for the old Access / Jet setup where you built an application with VB or ?? and distributed it.  Generally few or single users.  So you can write applications with a DB, and distribute it royalty free, no license fee.

    It is also good as a replication conterpart, put an small subset of your DB on roving laptops, salesmen ??, so they have the info they need to do their job.  Then whenever they connect you swap updates.

    It has a few other downsides, DB size, connection limits (>5 and it slows itself down ) and no fancy tools. But is supposedly the same basic engine as it's big brother.  This would allow upsizing with little pain.

    Developer edition is just that, Development, NO production.  It is licensed per developer.


    KlK

  • June 22, 2004 at 9:41 am

    #511459

    thanks guys! that was helpful. I was a little confused there for a moment.

    "Developer edition is just that, Development, NO production.  It is licensed per developer."

    So you can't use Developer to create small DB's for your app and distribute them as with MS Access?

     

    Thanks again!!!!

  • June 22, 2004 at 10:15 am

    #511465

    Yes, you can create DBs and distribute the DB.

    But you still need an access method, ie JET, or MSDE.

     


    KlK

  • June 22, 2004 at 10:28 am

    #511468

    What do you mean about "access method"? I know that JET is an engine.

  • June 22, 2004 at 11:42 am

    #511487

    SQL Server would be an access method, if you create a DB, and want to read it with Access, VB or ... you need something to manage it.  Maybe DBMS would a better term.

    If you put the MDF on a machine without SQL, or MSDE you can't "Access" it. ODBC, or OLEDB are connections.

    If you put SQL Server on you have to pay for it, MSDE is free.


    KlK

  • June 22, 2004 at 3:41 pm

    #511524

    Thanks very much!

  • June 23, 2004 at 1:46 am

    #511566

    MSDE is basically the SQL Server Engine with no GUI Admin tools.  You can hook Access to it and use Access as your Front End / Admin Tool. MSDE also limits a database to 2GB and has a workload governor which retards jobs six and up when there are five concurrent jobs running until there are no more than 5.  If you have Enterprise Manager from some other licensed means then you are free to use EM with MSDE.

    When Access is used in this way, JET is not used.

  • June 23, 2004 at 8:13 am

    #511623

    Thanks guys. that was very informative!!!

Viewing 10 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply