Đang chuẩn bị nút TẢI XUỐNG, xin hãy chờ
Tải xuống
The Real MTCS SQL Server 2008 Exam 70/432 Prep Kit- P86: Congratulations on your journey to become certified in SQL Server 2008. This book will help prepare you for your exam and give you a practical view of working with SQL Server 2008. | Managing Replication Chapter 9 407 Conflict tables are created to store conflict information. The conflict tables match the schema of the published tables each published table is scripted and then the script is used to create the conflict table in the publication database. Conflict tables are named in the form dbo.MSmerge_conflict_ Publication _ Article . Components Merge replication uses two components Snapshot Agent and Merge Agent. If the publication is unfiltered or uses static filters the Snapshot Agent creates a single snapshot. If the publication uses parameterized filters the Snapshot Agent creates a snapshot for each partition of data. The Merge Agent applies the initial snapshots to the Subscribers. It also merges incremental data changes that occurred at the Publisher or Subscribers after the initial snapshot was created and detects and resolves any conflicts according to rules you configure. Replication Configuration Though there are several replication types which we discussed earlier configuration of those types are almost similar. Therefore in this chapter we will look at how to configure Merge Replication. Later we will discuss how to configure Peer-to-Peer Replication. Configuration of Distributor Before configuring any replications on your server you need to configure your distribution. If no distribution is available when configuring publication the publication wizard will ask for relevant information to configure the distribution. EXERCISE 9.1 Configuring Distributor 1. Launch Open SQL Server Management Studio from Program Files SQL Server 2008. 2. Supply the correct authentication for you to login to the SQL Server in which you are going to configure the distribution. 3. In the SQL Server Management Studio navigate to Replication node in the Object Explorer. Right-click the Replication node and select Configure Distribution in the context menu. 408 Chapter 9 Managing Replication 4. After the start page you will be taken to the screen shown in .