Re: MYSQL what should I know

From: YYZ (notapplicable)
Date: 05/13/04 

Date: Thu, 13 May 2004 10:45:05 -0500

"Guy Cohen" <support@mcam2u.com> wrote in message
news:OYvprXPOEHA.2920@tk2msftngp13.phx.gbl...
> Thank you ALLLL for the replies
> ..
> Ahem, what is MSDE ?
> Where can I get it ?

Adding to Unforgiven's post, MSDE is Microsoft Desktop Engine (I think that's
what it stands for...that or Microsoft Data Engine...)

What it is is a version of SQL Server with limitations imposed. Such as, you
can only have 5 concurrent connections, your databases are limited to 2 GB in
size (but you can have many databases in one instance, and you can have up to 16
instances per machine, I think).

It supports Views, Stored Procedures, everything that SQL Server does.

BTW, take my comments as a place to start researching. My numbers might be off
a bit, and there might be some other limitations that I haven't listed. How it
was explained to me is that it is SQL Server with no graphical interface (but
supposedly you can buy Enterprise manager and Query analyzer for $75 or so from
MS), and that it has a few arbitrary limits on DB size and connections. What's
nice about it is that if you eventually NEED to move to an enterprise database,
supposedly you can convert it to SQL Server with absolutely NO changes in code
or functionality, simply by flipping a switch.

Matt

Relevant Pages

  • RE: How to configure WSS to use SQL server instead of MSDE
    ... This is why, in this post, I wanted to focus on only WSS features. ... Apparently WSS DOES NOT SUPPORT SQL Server since it has no tool (that we ... >>MSDE databases for its configuration and content ...
    (microsoft.public.sharepoint.windowsservices)
  • Cannot insert explicit value for identity...
    ... I am developing an integration process between two databases. ... The main database is the SQL Server, the MSDE will contain a really ...
    (comp.databases.ms-sqlserver)
  • Re: Newbie Questions
    ... I have noticed that some of the documentation talkes about SQL Server ... > MSDE is the old database engine there is now as well SQL server Express, ... > hard to find (mostly everything is done with scripting ASP style). ... How do I use the MSDE functionality in relation to databases? ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Change default to named instance??
    ... Take a backup of all databases ... Stop SQL Server and copy the MDF and LDF to a safe place ... Un Install the MSDE ... > conflicts with other app's msdes, I now want to use a named instance. ...
    (microsoft.public.sqlserver.msde)
  • Re: Relocate MSDE 2000 database?
    ... Most of the 2000 versions of SQL Server and thus MSDE have been pulled. ... It can be purchased for about $40 and can manage any version of SQL Server. ... It will be increasingly expensive to support no-supported databases as time goes on. ... post -- these databases are installed and deployed by 3rd party apps ...
    (microsoft.public.sqlserver.msde)