"JosephPruiett" <JosephPruiett@discussions.microsoft.com> wrote in message
news:449CAC31-3FAE-4FB9-8C6E-7805C263B873@microsoft.com...
> SQL Server 2005 Features Comparison
> Published: May 5, 2005
>
> Microsoft has redesigned the SQL Server 2005 product family to better meet
> the needs of each customer segment with four new editions: Express,
> Workgroup, Standard, and Enterprise. As a low-cost mainstream database,
> SQL
> Server 2005 will deliver unprecedented value and functionality compared
> with
> competitive solutions. The four new editions will offer a range of
> features,
> from high availability and robust scalability to advanced business
> intelligence tools, designed to empower users across an organization
> through
> a more secure, reliable, and productive data management platform.
> Additionally, with the reduced application downtime, robust scalability
> and
> performance, and tight security controls, SQL Server 2005 represents a
> dramatic step forward in supporting the most demanding enterprise systems
> in
> the world. Because SQL Server is part of Windows Server System, customers
> also receive the added benefits of reduced total cost of ownership and
> faster
> development time through the increased manageability and integration that
> result from the common engineering strategy implemented across Windows
> Server
> System products. The table below presents details about each of the
> different
> editions.
>
> Note: In the following table, the "Comments" column provides comments on
> the
> specified feature. Numbers next to check marks indicate footnotes that
> appear
> at the bottom of the page.
>
> Refer to this website to get the comparison checklist breakdown.
> http://www.microsoft.com/sql/2005/productinfo/sql2005features.mspx
>
> 1 Supports only two CPUs per server
> 2 Supports only two nodes
> 3 Subscriber only
> 4 Publish to up to 25 subscribers
> 5 Publish to up to five subscribers
>
> There should not be an issue with developing processes on express and then
> moving to the full version. You would have more features and capabilities
> on
> full version rather than the express. Express has a database limit of 4
> GB
> so if you are going to working with lage amounts of data in one database
> you
> would not want to go with the express version, as Enterprise edition is
> going
> to give you the most flexibility. As for the Access part of you question
> I
> would have to say no because access and MS Sql are two different animals
> not
> to be compared to each other as Access is less scalable that SQL and
> Access
> writes its queries alot different than SQL Server.
>
> Hope this helps.
> JP
>
>
>
> "John" wrote:
>
>> Hi
>>
>> What is the feature comparison of sql server 2005 full and the express
>> product? If an application is developed on one, will it run on the other?
>> Can we say that express is for clients who have previously gone for ms
>> access?
>>
>> Thanks
>>
>> Regards
>>
>>
>>

"John" wrote:

> Hi
>
> What is the feature comparison of sql server 2005 full and the express
> product? If an application is developed on one, will it run on the other?
> Can we say that express is for clients who have previously gone for ms
> access?
>
> Thanks
>
> Regards
>
>