Wednesday, March 21, 2012

MSDE or MS SQL Server 2000 Developer Edition ?

I have been using MSDE and I recently got Microsoft SQL ServerTM 2000 Developer Edition as part of my MAPS pack. Can and should I replace MSDE with Microsoft SQL Server 2000 Developer Edition on my development pc? Thanks in advance for any advice on pros and cons or known issues?Please excuse my ignorance -- what a MAPS pack?

I think the benefit of installing the Developer Edition would be that you'd be able to use the Client Tools -- such as Enterprise Manager and Query Analyzer. I know people that have bought just the Developer Edition for legal use of those tools.

The Developer Edition includes all of the functionality of the Enterprise Edition, but you cannot use it for production. If you are going to be developing mobile applications needing SQL Server CE, owning the Developer Edition gives you the rgiht to redistribute SQL Server CE.

This white paper explains the differences between the editions and should help you to make an informed choice:Choosing an Edition of SQL Server 2000.

Terri|||Thanks for the info. There is some (M)icrosoft (A)ction (P)ack info:

The Action Pack Update kits are sent quarterly. To see a complete listing of the
contents of the Update kit (in the US and Canada), please visit:

http://members.microsoft.com/partner/salesmarketing/partnermarket/actionpack/updatekits.aspx

Thank you for continuing your subscription to the Microsoft Action Pack!

-The Worldwide Partner Programs Team|||Everywhere it says NT and 2000. Does it run on XP. Thanks.|||Well, I can tell you that I have XP Pro an I am running SQL Server 2000 Personal Edition successfully, and my colleague is also running XP Pro but with the SQL Server 2000 Developer Edition and he has been able to use it successfully.

YMMV

Terri

No comments:

Post a Comment