Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Comparison of SQL Server 2005 Editions


Comparison of SQL Server 2005 Editions

Author
Message
Brian Knight
Brian Knight
SSCommitted
SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)

Group: Moderators
Points: 1955 Visits: 235
Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/bknight/comparisonofsqlserver2005editions.asp

Brian Knight
Free SQL Server Training Webinars
dwebb
dwebb
SSC Rookie
SSC Rookie (39 reputation)SSC Rookie (39 reputation)SSC Rookie (39 reputation)SSC Rookie (39 reputation)SSC Rookie (39 reputation)SSC Rookie (39 reputation)SSC Rookie (39 reputation)SSC Rookie (39 reputation)

Group: General Forum Members
Points: 39 Visits: 111
Thanks for the information.



Greg Larsen
Greg Larsen
Ten Centuries
Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)

Group: General Forum Members
Points: 1051 Visits: 290

Humm....No more developer addition. Where does that leave developers for having a cheap copy to do development work? I haven't looked at the Express version for 2005. Will the Express version have enough functionality for developers deploying Standard or Enterprise solutions?



Gregory A. Larsen, MVP
Kathi Kellenberger
Kathi Kellenberger
Right there with Babe
Right there with Babe (787 reputation)Right there with Babe (787 reputation)Right there with Babe (787 reputation)Right there with Babe (787 reputation)Right there with Babe (787 reputation)Right there with Babe (787 reputation)Right there with Babe (787 reputation)Right there with Babe (787 reputation)

Group: General Forum Members
Points: 787 Visits: 341

Overall this looks like good news. I am disappointed that the Report Builder is only available with Enterprise version. We do have 4 or 5 Enterprise Edition installations now and have software assurance so we should be able to upgrade to 2005 without additional cost.

I assume that if you are using Reporting Services on an 2005 Enterprise Edition installation that you can still run reports against databases residing on standard edition?



Aunt Kathi
Linchpin People Teammate
SQL Server MVP
Author of Expert T-SQL Window Functions
Jonr
Jonr
SSC-Enthusiastic
SSC-Enthusiastic (148 reputation)SSC-Enthusiastic (148 reputation)SSC-Enthusiastic (148 reputation)SSC-Enthusiastic (148 reputation)SSC-Enthusiastic (148 reputation)SSC-Enthusiastic (148 reputation)SSC-Enthusiastic (148 reputation)SSC-Enthusiastic (148 reputation)

Group: General Forum Members
Points: 148 Visits: 65
Greg,
I believe the Developer Edition will have all of the features of the Enterprise Edition, but with the development only licensing restrictions, as per SQL Server 2000.


Jon
Brian Knight
Brian Knight
SSCommitted
SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)

Group: Moderators
Points: 1955 Visits: 235
Hi Greg, there will still be a dirt cheap developer edition just like SQL Server 2000's model is today.

Brian Knight
Free SQL Server Training Webinars
Greg Larsen
Greg Larsen
Ten Centuries
Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)

Group: General Forum Members
Points: 1051 Visits: 290

It's good to see there will still be a developer addition. I just didn't see it on the posts from Microsoft on 2/24 or your article, so I was just wondering. Any idea where I might see as note (web page) from Microsoft about the developer addition.



Gregory A. Larsen, MVP
bav
bav
Forum Newbie
Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)

Group: General Forum Members
Points: 2 Visits: 1

A main difference of SQL Express compared to the other (non free) editions is the lack of the SQL Server Agent providing professional
job scheduling and other goodies. Example for making backup and keeping track in history records, all from within one single package.

When upgrading MSDE to SQL Express all this nice stuff is gone.
There is not easy alternative to this. There are ways to use the
Windows scheduler but ... the development, maintenance, tracing is completely different. Developers will find a new challenge to
package all this :-) but in the end End users and Customers
(no system administrators) will not be happy at all.

You should never remove functionality from a product that
is already established well in the field. The result will be that
MSDE 2000 will still be used for several years, even for new customers.

I see no reason why you increase the 'freeware' limit from 2GB
to 4GB. If you need more than 2GB disk, you simply buy the
non-free versions, and the customer understands.

regards





Brian Knight
Brian Knight
SSCommitted
SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)

Group: Moderators
Points: 1955 Visits: 235
I saw it initially in an interview with Tom Rizzo. Also, the beta version that's being distributed today is the Developer Edition.

Brian Knight
Free SQL Server Training Webinars
Yelena Varshal
Yelena Varshal
Hall of Fame
Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)

Group: General Forum Members
Points: 3480 Visits: 593

Brian, thanks. Good summary. Still need to know more:

What is BAV saying about Express Edition without Agent? What about the backup job for example? OSQL with Windows Scheduler???

Abour Reports: Developer Edition 2005 Beta contains BI Development Studio. Will it continue to contain it?

Personal Edition: did not hear about this one in 2005. The advantage of Personal Edition in 2000 is that it is licensed as a client. It is a counterpart of the Standard Edition for Development. We use it a lot. Do you think it will be there in 2005?

Report Server itself: currently in 2000 is free with Standard Edition. Do you think it still will be provided with Standard?

Thanks,

Yelena




Regards,
Yelena Varshal

Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search