发布属性,项目Publication Properties, Articles

适用于:Applies to: 是SQL ServerSQL Server(所有支持的版本)yesSQL ServerSQL Server (all supported versions) 是Azure SQL 托管实例Azure SQL Managed InstanceYesAzure SQL 托管实例Azure SQL Managed Instance适用于:Applies to: 是SQL ServerSQL Server(所有支持的版本)yesSQL ServerSQL Server (all supported versions) 是Azure SQL 托管实例Azure SQL Managed InstanceYesAzure SQL 托管实例Azure SQL Managed Instance

“发布属性” 对话框的 “项目” 页包含与发布中所包含项目有关的信息。使用该页,可以将项目添加到现有发布或从现有发布删除项目;并允许您更改项目属性和列筛选。The Articles page of the Publication Properties dialog box: contains information about the articles contained in a publication; allows you to add articles to and drop articles from existing publications; and allows you to change article properties and column filtering.

备注

创建发布之后,某些属性更改要求新的快照。After a publication is created, some property changes require a new snapshot. 如果发布具有多个订阅,某些更改还会要求重新初始化所有订阅。If a publication has subscriptions, some changes also require all subscriptions to be reinitialized. 有关详细信息,请参阅更改发布和项目属性向现有发布添加项目和从中删除项目For more information, see Change Publication and Article Properties and Add Articles to and Drop Articles from Existing Publications.

如果发布的数据库对象依赖于一个或多个其他数据库对象,则必须发布所有被引用对象。If you are publishing a database object that depends on one or more other database objects, you must publish all referenced objects. 例如,如果要发布的视图依赖于一个表,则也必须发布该表。For example, if you publish a view that depends on a table, you must publish the table also.

无法发布的对象旁边有一个红色图标,并在向导页底部的信息面板中附有说明。Objects that cannot be published have a red icon next to them, with an explanation in the information panel at the bottom of the wizard page. 无法发布下列对象:The following objects cannot be published:

  • 加密的对象。Encrypted objects.

  • 包含允许 Null 的列的索引视图。Indexed views containing columns that allow NULL.

  • 无法在事务发布中发布没有主键的表。Tables without primary keys cannot be published in transactional publications.

  • 在为排队更新订阅启用的合并发布和事务发布中,无法发布表。Tables cannot be published in both a merge publication and a transactional publication enabled for queued updating subscriptions. 有关在多个发布中发布项目的详细信息,请参阅发布数据和数据库对象中的“在多个发布中发布表”部分。For more information about publishing an article in more than one publication, see the "Publishing Tables in More Than One Publication" section in Publish Data and Database Objects.

Oracle 发布服务器Oracle Publishers

Oracle 发布服务器的其他注意事项:There are additional considerations for Oracle Publishers:

列筛选器Column Filters

通过展开 “要发布的对象” 窗格中的表,然后只选择需要的列,可以对此页上的列进行筛选(可以在此向导的 “筛选表行” 页上筛选行)。Filter columns on this page by expanding a table in the Objects to publish pane and then selecting only the columns required (rows can be filtered in the Filter Table Rows page of this wizard). 由于包括安全(防止复制敏感数据)和性能(例如,避免复制较大的二进制大型对象 (BLOB) 列)在内的很多原因,筛选列非常有用。Filtering columns is useful for a number of reasons, including security (preventing sensitive data from being replicated) and performance (avoiding replication of large binary large object (BLOB) columns, for example). 有关列筛选(包括无法筛选的列类型的列表)的详细信息,请参阅筛选已发布数据For more information about column filtering, including a list of column types that cannot be filtered, see Filter Published Data.

选项Options

使用 “要发布的对象” 窗格,可以:The Objects to publish pane allows you to:

  • 查看所有可用于复制的对象。View all objects available for replication.

  • 通过选中该对象旁边的复选框,可以将项目添加到发布。Add an article to a publication by selecting the check box next to that object.

  • 通过清除该对象旁边的复选框,可以从发布删除项目。Drop an article from a publication by clearing the check box next to that object. 有关何时可以删除项目的信息,请参阅向现有发布添加项目和从中删除项目For information about when articles can be dropped, see Add Articles to and Drop Articles from Existing Publications.

  • 通过选中对象类型(如 “表” )旁边的复选框,将特定类型(如表)的所有对象包括在发布中。Include all objects of a particular type (such as a table) in the publication by selecting the check box next to that object type (such as Tables).

  • 展开表节点可以查看表中的列。Expand table nodes to see the columns in the table.

  • 通过清除列旁边的复选框来从发布中筛选表列,或通过选中该复选框来包含未发布的列。Filter table columns out of a publication by clearing the check box next to the column or include unpublished columns by selecting the check box.

  • 右键单击窗格中的对象可以查看该对象的命令菜单。Right-click an object in the pane to see a menu of commands for that object.

项目属性Article Properties
单击 “项目属性” ,再单击下列选项之一:Click Article Properties , and then click one of the following:

  • 单击“设置突出显示的 <ObjectType> 的属性”以启动“项目属性 - <ObjectName>”对话框;在此对话框中进行的属性更改仅应用于在“项目”页上的对象窗格中突出显示的对象 。Click Set Properties of Highlighted <ObjectType> Article to launch the Article Properties - <ObjectName> dialog box; property changes made in this dialog box are applied only to the object that is highlighted in the object pane on the Articles page.

  • 单击“设置所有 <ObjectType> 项目的属性”以启动“所有 <ObjectType> 项目的属性”对话框;在此对话框中进行的属性更改应用于“项目”页上的对象窗格中该类型的所有对象,包括尚未选择进行发布的对象。 Click Set Properties of All <ObjectType> Articles, to launch the Properties for All <ObjectType> Articles dialog box; property changes made in this dialog box are applied to all objects of that type in the object pane on the Articles page, including ones not yet selected for publication.

    备注

    在“所有 <ObjectType> 项目的属性”对话框中进行的属性更改会替代之前在“项目属性 - <ObjectName>”对话框中进行的任何更改。 Property changes made in the Properties for All <ObjectType> Articles dialog box override any made previously in the Article Properties - <ObjectName> dialog box. 例如,若要为某对象类型的所有项目设置一些默认值,但还希望为单个对象设置一些属性,请首先设置所有项目的默认值。If, for example, you want to set a number of defaults for all articles of an object type, but also want to set some properties for individual objects, set the defaults for all articles first. 然后再设置单个对象的属性。Then set the properties for the individual objects.

已选中的表仅用于下载Highlighted table is download-only
仅限合并复制。Merge replication only. 仅限 MicrosoftMicrosoft SQL Server 2005 (9.x)SQL Server 2005 (9.x) 及更高版本。MicrosoftMicrosoft SQL Server 2005 (9.x)SQL Server 2005 (9.x) and later versions only. 选择此项可以指定在使用客户端订阅后不允许在订阅服务器上进行更改。Select to specify that changes are disallowed at the Subscriber if a client subscription is used. 因为仅供下载的项目不能在订阅服务器上更新,所以跟踪元数据不会发送到订阅服务器。Because download-only articles cannot be updated at the Subscriber, tracking metadata is not sent to Subscribers. 这可以减少订阅服务器上的存储量并提高性能,特别是当网络连接较慢时。This can lead to reduced storage on the Subscribers and a performance benefit, especially if the network connection is slow. 此选项对应于 “项目属性” 对话框中的选项 “同步方向” 的值 “仅下载到订阅服务器,禁止订阅服务器更改”This option corresponds to a value of Download-only to Subscriber, prohibit Subscriber changes for the option Synchronization direction in the Article Properties dialog box. 有关详细信息,请参阅使用仅下载项目优化合并复制性能For more information, see Optimize Merge Replication Performance with Download-Only Articles.

仅显示列表中已选中的对象Show only checked objects in the list
选中此复选框可以只显示对象窗格中选定的项目。Select this check box to show only those articles that are selected in the object pane.

另请参阅See Also

Create a Publication Create a Publication
查看和修改发布属性 View and Modify Publication Properties
创建并应用初始快照 Create and Apply the Initial Snapshot
重新初始化订阅 Reinitialize a Subscription
发布数据和数据库对象Publish Data and Database Objects