Personal vs MSDE

Besides the extra storage space. Why would I want to use
the Personal Edition(not free) instead of MSDE (free). I
have read the "Choosing an Edition" related information
but besides space issues, is there any reason not to use
MSDE in favor of the Personal Edition?
Thanks,
MikeHi MT,
With MSDE you don't get "tools". We supply some (details at our site).
Google for others.
HTH,
--
Greg Low (MVP)
MSDE Manager SQL Tools
www.whitebearconsulting.com
"MT" <miketownsend33@.yahoo.com> wrote in message
news:07e001c34b6b$1c866720$a401280a@.phx.gbl...
> Besides the extra storage space. Why would I want to use
> the Personal Edition(not free) instead of MSDE (free). I
> have read the "Choosing an Edition" related information
> but besides space issues, is there any reason not to use
> MSDE in favor of the Personal Edition?
> Thanks,
> Mike|||Which "Tools"
Mike
>--Original Message--
>Hi MT,
>With MSDE you don't get "tools". We supply some (details
at our site).
>Google for others.
>HTH,
>--
>Greg Low (MVP)
>MSDE Manager SQL Tools
>www.whitebearconsulting.com
>"MT" <miketownsend33@.yahoo.com> wrote in message
>news:07e001c34b6b$1c866720$a401280a@.phx.gbl...
>> Besides the extra storage space. Why would I want to
use
>> the Personal Edition(not free) instead of MSDE (free).
I
>> have read the "Choosing an Edition" related information
>> but besides space issues, is there any reason not to
use
>> MSDE in favor of the Personal Edition?
>> Thanks,
>> Mike
>
>.
>|||hi MT,
"MT" <MikeTownsend33@.yahoo.com> ha scritto nel messaggio
news:0a4901c34b8d$230f8f00$a301280a@.phx.gbl...
> Which "Tools"
all the client graphical tools to manage SQL Server like Enterpise Manager,
Query Analyzer, Profiler...
MSDE only provides oSql.exe, a command line utility by which you can almost
do the same things but the hard way... via T-SQL statements... =;-) rather
then via a nifty user interface...
for your convenience you can have a look at a prj of mine, at the link
following my sign., that provides a fee user interface similar to Enterprise
Manager..
hth
Andrea Montanari
montanari_andrea@.virgilio.it
http://www.asql.biz/DbaMgr.shtm
DbaMgr2k ver 0.4.0 - DbaMgr ver 0.50.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply|||MSDE is just the relational data engine from within the entire SQL Server
product. That's why its name is Microsoft SQL Server 2000 Desktop ENGINE.
Personal Edition is a full EDITION of SQL Server including:
- Tools: Query Analyzer, Enterprise Manager, Profiler, Index Tuning Wizard,
etc.
- Analysis Services: OLAP, Data Mining
- Various bits and pieces of development libraries, legacy utilities, etc.
In general the scenarios for MSDE vs Personal Edition are very different.
MSDE is intended for use embedded within an application, not as a
multi-application database server. Personal Edition is intended primarily
as a client-side store for an application that runs both on the desktop and
on a server. Since the clients already require a CAL (or the SQL Server
server has Processor Licenses) there is no additional cost to use Personal
Edition in this scenario.
Personal Edition has a secondary use, which is as a way to install a full
edition of SQL Server 2000 on a Windows Desktop OS. So if you purchase
Standard Edition but want to install on Windows XP, you have to install
Personal Edition. You are paying a lot for a server product and then
crippling it (both in the OS selection and the database edition you need to
install), but some people are willing to do that. They save some $ on the
OS, and they get the full SQL Server product other than the governor. If it
meets their needs, great.
MSDE technically isn't free. The MSDE model is that you buy a development
tool and you receive the right to redistributed MSDE at no charge with (and
as part of) applications that you develop USING THAT TOOL. Microsoft has one
no cost development tool, ASP.NET Web Matrix, that includes MSDE as well.
But the no cost redistribution of MSDE in that case is limited to
applications developed with Web Matrix. There is another scenario where you
purchase a SQL Server 2000 edition and get MSDE redistribution rights. In
this case the SQL Server 2000 edition takes on the role of the development
tool.
Hal Berenson, SQL Server MVP
True Mountain Group LLC
"MT" <miketownsend33@.yahoo.com> wrote in message
news:07e001c34b6b$1c866720$a401280a@.phx.gbl...
> Besides the extra storage space. Why would I want to use
> the Personal Edition(not free) instead of MSDE (free). I
> have read the "Choosing an Edition" related information
> but besides space issues, is there any reason not to use
> MSDE in favor of the Personal Edition?
> Thanks,
> Mike|||Thanks!! Much clearer now.
As we have purchased several processor licenses for the
Standard Edition of SQL Server and in some cases we have
installed MSDE on a few laptops so that users could use
the same applications that the Standard Edition is using
to test/develop or in one case subscribe to.
We now have one user who wishes to have a copy of the
Personal Edition installed for the same purpose, and
we're reluctant to do so.. is there a reason that you
could think of why they would need to use the Personal
Edition as opposed to MSDE?
MT
>--Original Message--
>MSDE is just the relational data engine from within the
entire SQL Server
>product. That's why its name is Microsoft SQL Server
2000 Desktop ENGINE.
>Personal Edition is a full EDITION of SQL Server
including:
>- Tools: Query Analyzer, Enterprise Manager, Profiler,
Index Tuning Wizard,
>etc.
>- Analysis Services: OLAP, Data Mining
>- Various bits and pieces of development libraries,
legacy utilities, etc.
>In general the scenarios for MSDE vs Personal Edition
are very different.
>MSDE is intended for use embedded within an application,
not as a
>multi-application database server. Personal Edition is
intended primarily
>as a client-side store for an application that runs both
on the desktop and
>on a server. Since the clients already require a CAL
(or the SQL Server
>server has Processor Licenses) there is no additional
cost to use Personal
>Edition in this scenario.
>Personal Edition has a secondary use, which is as a way
to install a full
>edition of SQL Server 2000 on a Windows Desktop OS. So
if you purchase
>Standard Edition but want to install on Windows XP, you
have to install
>Personal Edition. You are paying a lot for a server
product and then
>crippling it (both in the OS selection and the database
edition you need to
>install), but some people are willing to do that. They
save some $ on the
>OS, and they get the full SQL Server product other than
the governor. If it
>meets their needs, great.
>MSDE technically isn't free. The MSDE model is that you
buy a development
>tool and you receive the right to redistributed MSDE at
no charge with (and
>as part of) applications that you develop USING THAT
TOOL. Microsoft has one
>no cost development tool, ASP.NET Web Matrix, that
includes MSDE as well.
>But the no cost redistribution of MSDE in that case is
limited to
>applications developed with Web Matrix. There is
another scenario where you
>purchase a SQL Server 2000 edition and get MSDE
redistribution rights. In
>this case the SQL Server 2000 edition takes on the role
of the development
>tool.
>
>--
>Hal Berenson, SQL Server MVP
>True Mountain Group LLC
>
>"MT" <miketownsend33@.yahoo.com> wrote in message
>news:07e001c34b6b$1c866720$a401280a@.phx.gbl...
>> Besides the extra storage space. Why would I want to
use
>> the Personal Edition(not free) instead of MSDE (free).
I
>> have read the "Choosing an Edition" related information
>> but besides space issues, is there any reason not to
use
>> MSDE in favor of the Personal Edition?
>> Thanks,
>> Mike
>
>.
>