MS SQL Server - Standard Edition vs. Enterprise Edition

Author

Standard Edition vs. Enterprise Edition

Chen

2005-03-31, 8:01 pm

Hi,

Can someone tell what different with Standard Edition and Enterprise
Edition. I knew those prices different. In our production Internet and
Intranet need install SQL Server 2000, I just want know if I need do
replication for those databases located in this server to secondary site,
which one is the best to choose?

Regards,
-Chen

Geoff N. Hiten

2005-03-31, 8:01 pm

Perhaps this will help:
http://www.microsoft.com/sql/evalua...es/choosing.asp

FYI, Replication is the same between editions. Log shipping is included in
Enterprise Edition but there are third party bolt-ons that work with
Standard Edition.

Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator

"Chen" <Chen@discussions.microsoft.com> wrote in message
news:A8588F78-E7B6-465B-B29C- 13A16526B700@microso
ft.com...
> Hi,
>
> Can someone tell what different with Standard Edition and Enterprise
> Edition. I knew those prices different. In our production Internet and
> Intranet need install SQL Server 2000, I just want know if I need do
> replication for those databases located in this server to secondary site,
> which one is the best to choose?
>
> Regards,
> -Chen

Jack

2005-03-31, 8:01 pm

As far as replication, both Enterprise and Standard editions provide same
functionalities. Check the following link for more detail.

http://msdn.microsoft.com/library/d..._ar_ts_8ynn.asp

"Chen" wrote:

> Hi,
>
> Can someone tell what different with Standard Edition and Enterprise
> Edition. I knew those prices different. In our production Internet and
> Intranet need install SQL Server 2000, I just want know if I need do
> replication for those databases located in this server to secondary site,
> which one is the best to choose?
>
> Regards,
> -Chen

Hari Prasad

2005-03-31, 8:01 pm

Hi Chen,

Please see the below article to detail the difference in editions:-

http://www.sqlservercentral.com/col... /> edition.asp

Replication:-

This table shows what replication types are supported by the editions of SQL
Server 2000:

Editions Snapshot Transactional Merge
Enterprise Yes Yes Yes
Standard Yes Yes Yes
Personal Yes Subscriber only Yes
Developer Yes Yes Yes
Desktop Engine Yes Subscriber only Yes
SQL Server CE No No Anonymous Subscriber only

Thanks
Hari
SQL Server MVP

"Chen" <Chen@discussions.microsoft.com> wrote in message
news:A8588F78-E7B6-465B-B29C- 13A16526B700@microso
ft.com...
> Hi,
>
> Can someone tell what different with Standard Edition and Enterprise
> Edition. I knew those prices different. In our production Internet and
> Intranet need install SQL Server 2000, I just want know if I need do
> replication for those databases located in this server to secondary site,
> which one is the best to choose?
>
> Regards,
> -Chen

Sponsored Links