Microsoft SQL Server 2008 R2 Unleashed- P66:SQL Server 2005 provided a number of significant new features and enhancements over what was available in SQL Server 2000. This is not too surprising considering there was a five-year gap between these major SQL Server 2008 is not as much of a quantum leap forward from SQL Server 2005 | 594 CHAPTER 19 Replication Join filtering allows you to limit the rows you will publish via join criteria to another table. Figure shows a complex join that filters SalesOrderHeader rows that correspond to North East Territory customers only that is those with TerritorylD values of 1 or 2 . FIGURE Specifying a join filter on the SalesOrderHeader table limiting the sales rows that will be published by joining for the North East customers only . Creating Subscriptions Now that you have installed and configured the distributor enabled publishing and created a publication you can create subscriptions. Remember that two types of subscriptions can be created push or pull. Pull subscriptions allow remote sites to subscribe to any publication that they are allowed to but for this to work you must be confident that the administrators at the other sites have properly configured the subscriptions at their sites. Push subscriptions are easier to create because all the subscription processes are performed and administered from the publication distrib-utor point of view. This also makes using them the most common approach. For this example we use the New Subscription Wizard to create a push subscription 1. In SQL Server Management Studio locate the Replication node under the publication server the DBARCH-LT2 SQL08DE01 named instance in this example or the Replication node under the subscription server the DBARCH-LT2 SQL08DE03 named instance in this example . You can create a push subscription from either but we use the subscription server here . Open the Replication node navigate to the Local Subscription branch right-click and choose the New Subscriptions option. As you can see in Figure choosing this option launches the New Subscription Wizard where you can create one or more subscriptions to a publication and specify where and when to run the agents that synchronize the subscription. Download from Setting Up Replication 595 FIGURE .
