SQLServer2008培训_08+-+chs.ppt

Module 7: Implementing Replication Course 6231A * Discuss the ways to create a new publication. You can create a publication interactively by using the New Publication wizard in SQL Server Management Studio, or non-interactively by using Transact-SQL and the replication stored procedures supplied with SQL Server 2008. Name of the distributor. This page only appears the first time you create a publication for a SQL Server instance. Snapshot folder. This is the folder where SQL Server creates the files containing the snapshot data that is used to initialize subscriptions. Publication database. This is the database containing the data that you wish to publish. If you want to publish data from more than one database, you must create multiple publications. Publication type. You can select Snapshot publication, Transactional publication, Transactional publication with updateable subscriptions, or Merge publication. Subscriber types. This page only appears when you create a Merge publication. You can specify which versions of SQL Server subscribers might be using. Articles in the publication. A publication can contain several articles. An article can be data from a single object, such as a selection of columns from a database table, view or indexed view, or it can be a stored procedure or user defined function. Filters to apply to any published tables. You can apply a filter to each table and limit replication to rows that match the conditions specified by the filter. When to run the Snapshot Agent to generate snapshot data for the publication. You can create a snapshot immediately, and you can also arrange for the Snapshot Agent to execute periodically and generate a new snapshot containing the most recent version of the data in the published articles. Security settings for the agents used by the publication. Different types of replication use different replication agents. You must specify the security account that each of the agents will use. Publication name. Thi