tailieunhanh - Microsoft SQL Server 2008 R2 Unleashed- P62

Microsoft SQL Server 2008 R2 Unleashed- P62: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 | 554 CHAPTER 19 Replication Customer Sales 2 CustomerID TerritoryID AccountNumber CustomerType rowguid ModifiedDate SalesOrderHeader Sales 9 SalesOrderID RevisionNumber OrderDate DueDate ShipDate Status OnlineOrderFlag SalesOrderNumber PurchaseOrderNumber AccountNumber CustomerID ContactID SalesPersonID TerritoryID BillToAddressID ShipToAddressID FIGURE Horizontal and Join publication Joining customers that are stores type S to corresponding SalesOrderHeader rows. For instance if you wanted to update the Customer table for every customer via an UPDATE SQL statement the resulting Customer table updates would be replicated as a large multistep transaction involving at least 5 000 separate UPDATE statements at a minimum. This number of statements would significantly bog down your network. However with stored procedure execution articles only the execution of the stored procedure is replicated to the subscription server and the stored procedure not the numerous update statements is executed on that subscription server. Figure illustrates the difference in execution described earlier. Some subtleties when utilizing this type of data replication processing can t be overlooked such as making sure the published stored procedure behaves the same on the subscribing server side. Many more data replication terms are presented in this chapter but it is essential that you first learn about the different types of replication scenarios that can be built and the reasons any of them would be desired over the others. It is also worth noting that Microsoft SQL Server 2008 supports replication to and from many different heterogeneous data sources. In other words OLE DB and ODBC data sources can subscribe to SQL Server publications and they can receive data replicated from a number of data sources including Microsoft Exchange Microsoft Access Oracle and DB2. Download from Replication Scenarios 555 UPDATE Customers set AccountNumber null where CustomerID 1 and .