Wednesday, March 21, 2012

Does replication work with SQL2k standard

Hi,
Does replication work between two SQL2k standard servers? Or do I need
advanced servers?
I'm in the process of migrating from another vendor, and a friend just told
me that I need advanced server to do replication!!!! Is he correct?
TIA,
Edgard L. Riba
Edgard,
yes there's no problem using Standard Edition. Replicationwise, the only
distinction I know of is Indexed views, which are only available in
Enterprise Edition and can be used as a tablelike article. Apart from that
as far as I know they are identical, both as a Publisher and Subscriber.
HTH,
Paul Ibison
|||Thanks Paul...
Edgard
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> escribi en el mensaje
news:O6QF#MHWEHA.2444@.TK2MSFTNGP11.phx.gbl...
> Edgard,
> yes there's no problem using Standard Edition. Replicationwise, the only
> distinction I know of is Indexed views, which are only available in
> Enterprise Edition and can be used as a tablelike article. Apart from that
> as far as I know they are identical, both as a Publisher and Subscriber.
> HTH,
> Paul Ibison
>
|||You can replicate indexed views with the standard and developer editions of SQL Server. However, the query optimizer will not use them in the query plan, unless you give it an optimizer hint.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"Paul Ibison" wrote:

> Edgard,
> yes there's no problem using Standard Edition. Replicationwise, the only
> distinction I know of is Indexed views, which are only available in
> Enterprise Edition and can be used as a tablelike article. Apart from that
> as far as I know they are identical, both as a Publisher and Subscriber.
> HTH,
> Paul Ibison
>
>
|||Thanks - I wasn't aware of this distinction.
Actually I got this from BOL
(http://msdn.microsoft.com/library/de...-us/architec/8
_ar_ts_1cdv.asp) which (incorrectly) claims they are not available in
Standard Edition, but you're spot on according to SQLServerMagazine
(http://www.winnetmag.com/SQLServer/A...657/40657.html).
Cheers,
Paul Ibison
sql

No comments:

Post a Comment