<div>
Thanks for the input tbsgadi but the article discusses different version ie 2000 with 2008 etc but I am discussing same version.<br />
<br />
Vmontelvao we want to create replication (copy) to a hosted SQL server off-site for fault tolerance. I will consider what you've said and find an article describing further differences.
</div>


Thanks for the input tbsgadi but the article discusses different version ie 2000 with 2008 etc but I am discussing same version.

Vmontelvao we want to create replication (copy) to a hosted SQL server off-site for fault tolerance. I will consider what you've said and find an article describing further differences.

<div>
Bugger actually tbsgadi &nbsp;you article is more relevant as I wont get downgrade rights to 2000!!!!! <br />
Any objections on splitting the points?<br />
<br />
Pbrane
</div>


Bugger actually tbsgadi  you article is more relevant as I wont get downgrade rights to 2000!!!!!
Any objections on splitting the points?

Pbrane

<div>
<div class="content wysiwyg-content">
Hi,<br />
We have a server running SQL 2000 Enterprise for approx 200 users. We would like to replicate the server but don't want to have to buy Enterprise.<br />
<br />
My question is: Can you replicate from SQL 2000 Enterprise to SQL 2000 STANDARD considering the users. ( we will be buying standard 2005 and using downgrade rights. )<br />
<br />
Thanks
</div>
</div>


Hi,
We have a server running SQL 2000 Enterprise for approx 200 users. We would like to replicate the server but don't want to have to buy Enterprise.

My question is: Can you replicate from SQL 2000 Enterprise to SQL 2000 STANDARD considering the users. ( we will be buying standard 2005 and using downgrade rights. )

Thanks

SQL 2000 Enterprise replication to SQL 2000 STANDARD

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.

Microsoft SQL Server 2005

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.