<div>
&gt;&gt; Is it best to use pull subscriptions when trying to minimize the impact on the main/production server/database?<br />
<br />
Yes and it is the recommended approach of implementing in Production servers where load in PROD servers is high.
</div>


>> Is it best to use pull subscriptions when trying to minimize the impact on the main/production server/database?

Yes and it is the recommended approach of implementing in Production servers where load in PROD servers is high.

<div>
I am also new to replication and I think that pull subscription is good to reduce publisher load. <br />
<br />
Hope that below link can help you to check it in detail:<br />
<a href="http://technet.microsoft.com/en-us/library/cc966539.aspx" rel="ugc">http://technet.microsoft.com/en-us/library/cc966539.aspx</a>
</div>


I am also new to replication and I think that pull subscription is good to reduce publisher load.

Hope that below link can help you to check it in detail:
http://technet.microsoft.com/en-us/library/cc966539.aspx [http://technet.microsoft.com/en-us/library/cc966539.aspx]

<div>
<div class="content wysiwyg-content">
I'm trying to set up transactional replication from a SQL Server 2005 SP3 server to SQL Server 2008 R2 server. I was hoping to use the push model, but I've been told that it can be strenuous on the server/database being replicated. Is it best to use pull subscriptions when trying to minimize the impact on the main/production server/database?
</div>
</div>


I'm trying to set up transactional replication from a SQL Server 2005 SP3 server to SQL Server 2008 R2 server. I was hoping to use the push model, but I've been told that it can be strenuous on the server/database being replicated. Is it best to use pull subscriptions when trying to minimize the impact on the main/production server/database?

SQL Server Replication

Microsoft SQL Server 2008 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. Major improvements include the  Always On technologies and support for unstructured data types.

Microsoft SQL Server 2008

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.