|
Home > Archive > MS SQL Server > May 2005 > sql server vs express
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
sql server vs express
|
|
|
| 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
| |
|
|
| JosephPruiett 2005-05-31, 9:23 am |
| 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/p...05features.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
>
>
>
| |
|
|
|
| Thanks for that. Will apps developed for 2005 work for 2000, in case a
client is not ready to upgrade to 2005 yet?
Thanks
Regards
"JosephPruiett" < JosephPruiett@discus
sions.microsoft.com> wrote in message
news:449CAC31-3FAE-4FB9-8C6E- 7805C263B873@microso
ft.com...[color=darkred]
> 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/p...05features.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:
>
| |
| Mike Epprecht \(SQL MVP\) 2005-05-31, 8:23 pm |
| Hi
Express is a MSDE replacement.
Regards
--------------------------------
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Chris Lieb" < ChrisLieb@discussion
s.microsoft.com> wrote in message
news:9F83EDF3-7553-4D98-A0CF- DF3914D258FE@microso
ft.com...[color=darkred]
> So, is the Express Edition a replacement for MSDE, or will MSDE still
> exist?
> With the features of EE and the fact that MS says that EE will be free,
> will
> there even be a need for MSDE anymore?
>
> Chris
>
> "Mike Epprecht (SQL MVP)" wrote:
>
| |
| Mike Epprecht \(SQL MVP\) 2005-05-31, 8:23 pm |
| Hi
As long as you don't use any of the new features introduced in Express 2005,
yes.
--
--------------------------------
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"John" <John@nospam.infovis.co.uk> wrote in message
news:%238%23ImGhZFHA
.3732@TK2MSFTNGP10.phx.gbl...
> Thanks for that. Will apps developed for 2005 work for 2000, in case a
> client is not ready to upgrade to 2005 yet?
>
> Thanks
>
> Regards
>
> "JosephPruiett" < JosephPruiett@discus
sions.microsoft.com> wrote in message
> news:449CAC31-3FAE-4FB9-8C6E- 7805C263B873@microso
ft.com...
>
>
| |
|
| Hmmm...is there a list somewhere of the new features?
Thanks
Regards
"Mike Epprecht (SQL MVP)" <mike@epprecht.net> wrote in message
news:uakFWpiZFHA.3488@tk2msftngp13.phx.gbl...
> Hi
>
> As long as you don't use any of the new features introduced in Express
> 2005, yes.
>
> --
> --------------------------------
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
>
> IM: mike@epprecht.net
>
> MVP Program: http://www.microsoft.com/mvp
>
> Blog: http://www.msmvps.com/epprecht/
>
> "John" <John@nospam.infovis.co.uk> wrote in message
> news:%238%23ImGhZFHA
.3732@TK2MSFTNGP10.phx.gbl...
>
>
| |
| Mike Epprecht \(SQL MVP\) 2005-05-31, 8:23 pm |
| Hi
Not that I am aware of. Don't forget, it is still in Beta.
Regards
--------------------------------
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"John" <John@nospam.infovis.co.uk> wrote in message
news:OXoNC6iZFHA.3288@TK2MSFTNGP10.phx.gbl...
> Hmmm...is there a list somewhere of the new features?
>
> Thanks
>
> Regards
>
> "Mike Epprecht (SQL MVP)" <mike@epprecht.net> wrote in message
> news:uakFWpiZFHA.3488@tk2msftngp13.phx.gbl...
>
>
|
|
|
|
|