SQL Server 2008 R2

As you create a publication, you add articles to be published. You can add articles from within the Publication Wizard or by using the sp_addmergearticle stored procedure.

When you use the Publication Wizard to create a publication, you select the articles you want to publish by selecting the check box next to each article. Because you have previously indicated in the Publication Wizard that this publication will have SQL Server Compact 3.5 Subscribers, the Publication Wizard will configure the articles appropriately. For more information about articles, see the "Article Options for Merge Replication" topic in SQL Server 2008 R2 Books Online.

The sp_addmergearticle stored procedure lets you add an article to a publication. This stored procedure has many arguments. One of the arguments, @compensate_for_errors, is modified in SQL Server Compact 3.5. SQL Server Compact 3.5 supports both @compensate_for_errors=false and @compensate_for_errors=true, whereas earlier versions supported only @compensate_for_errors=true. If your publication is set to @compensate_for_errors=false, you will receive errors on the subscriber until the problematic row is changed.

The following table lists arguments that either require a specific value or are ignored when you use SQL Server Compact 3.5 Subscribers.

Argument

Description or Requirement

@pre_creation_cmd

Only 'drop' is supported.

@creation_script

Ignored by SQL Server Compact 3.5.

@allow_interactive_resolver

Ignored by SQL Server Compact 3.5.

@logical_record_level_conflict_detection

Only 'false' is supported.

@logical_record_level_conflict_resolution

Only 'false' is supported.

SQL Server Compact 3.5 does not support synchronizing with publications that contain logical records. Therefore, the parameters related to logical record level conflicts must be set to 'false'.

The information in this topic applies to supported versions of SQL Server; for more information, see Hardware and Software Requirements.

Show: