SQL Server Developer Edition

[bbolte]

http://www.microsoft.com/sql/howtobuy/development.asp

MS is lowering the price on this version to $49. I'm assuming that it should have EM included but can't tell for sure. Anyone know what exactly this version is and what is included? If EM is included, it would be well worth the price...

[bbolte]

received a reply on the MS newsgroups. here is what he said, "The USD $49 figure is correct. The Developer Edition has all of the features of the full-blown Enterprise Edition. The difference is in licensing."

sounds cool, now just to wait for aug 1...

[asterix]

Its free on MSDN...

[bbolte]

i don't have msdn...

[asterix]

Now thats a crying shame
I have MSDN on DVD at work, I think we have just about all the software ever produced by microsoft, whch we use to make programs for customers.

[bbolte]

yeah. well the company i work for doesn't have it and i can't afford at the moment. maybe when i'm not spending all my money on school (this december!! woo hoo!) i can spring for it.

[M. Johansson]

MSDN subscriptions are like the most expensive things you can buy, EVER!

[bbolte]

MSDN subscriptions are like the most expensive things you can buy, EVER!

ain't that the truth. actually, the student discount on that is pretty good. i'll have to maybe grab it before i graduate...

[MarcusJT]

$49 seems quite reasonable, and is the "official" way to learn and develop on MSSQL. If it comes with supporting CDROMs and manuals, you should probably go for the deal.

However, if it's just a CDROM and a license, then you're much better off installing MSDE 2000 (obtained from an Office XP CD, but also from a few other MS and / or 3rd party application CDs), then downloading the SQL Server 2000 trial and installing the Enterprise tools only - that'll give you a virtually identical setup (to the "Developer Edition") for free!! Same tools, same engine, same help files, same everything.

That's what I and countless others use for local development, and it's as good as the real thing, *apart* from having a restricted number of concurrent users (which is fine for development).

[M. Johansson]

Warning - MSDE does NOT contain full-text searching. If that is something your app will need, you'll need the full developer edition.

[MarcusJT]

That's true, MJ! Not something I've ever needed to use, so didn't think of it...

[bbolte]

i have msde installed. but what i'm wanting is the Enterprise Manager. that's what i'm hoping is included in the developer edition.

[M. Johansson]

i have msde installed. but what i'm wanting is the Enterprise Manager. that's what i'm hoping is included in the developer edition.

Order the MSSQL trial edition from Microsoft. The enterprise manager and other tools doesn't expire.

http://www.microsoft.com/sql/evaluation/trial/

[Mike Borozdin]

Well, I use a trial edition of MS SQL that I obtained with some SQL book. It's written that it expires after 120 days but it hasn't expired for me

[bbolte]

Order the MSSQL trial edition from Microsoft. The enterprise manager and other tools doesn't expire.

http://www.microsoft.com/sql/evaluation/trial/

i've downloaded the trial version. maybe i'll try istalling that first.

[asterix]

The license expires, not the software.
And you do want to use licenced software, don't you?

[asterix]

MSDE doesn't do Indexed views, I recall. Also, maximum DB size of 2 GB and it throttles the number of threads used. Also, no chance of using fibers or paralell query execution. Also cant act as a transactional replication publisher, just a subscriber (bbut it can publish snapshot & megre replicas).

But apart from that, MSDE is by far the best desktop redistributable DB I have ever seen. It has an unbeaten value for money ration, in my opinion!

[MarcusJT]

i've downloaded the trial version. maybe i'll try istalling that first.

Yes, as I said earlier!


The order doesn't actually matter, but it will give you the enterprise tools, which is why I said what I said!