Question Locked

MSSQL 2000 Personal Edition and Desktop Edition

0 helpful
4 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Are they the same thing? I've tried to find Personal edition on the interent but this Desktop Edition keeps turning up...

?:|

4 replies

by larryd4

The Desktop Edition is a more barebones install, to be used with an application that needs a a SQL engine.

Quote from MS Web site refering to SQL Desktop

The SQL Server 2000 Desktop Engine (MSDE 2000) is a redistributable version of the SQL Server relational database engine. MSDE 2000 is designed to be distributed as a part of applications that require a local data store. Software developers can code the setup of their application to install an instance of MSDE 2000 and build a database to be used by the application. The application is then coded to perform any needed administration of that database and instance of MSDE 2000, and to use the data in the database to store application data.

The Personal Edition though essentially the same, including size limitaion, includes more management and development tools.

by jiminpa

From what I've read so far, Personal Edition is included in Standard Edition. I am trying to load it on an XP Pro machine. What I have not been able to find is how to "extract" personal edition from standard edition. Any thoughts?

by larryd4

I'v never had a need to install the Personal Edition and we have a seperate install CD that came with our MSDE Library. You may want to check and see if you can DL it from Microsoft. But actually extracting it from Standard, I'm sure can be done, but I wouldn't know where to start.

But I'm gonna nose around to see what I can find in our old SQL 2000 standard disk.

This discussion is closed to new replies.