This documentation is archived and is not being maintained.

Creating the Publication

You create publications for Microsoft SQL Server 2005 Compact Edition (SQL Server Compact Edition) by using standard SQL Server replication tools and techniques. The easiest way to create a publication is by using the Publication Wizard. You can also create the publication by using the sp_addmergepublication stored procedure.

In SQL Server 2000, the Publication Wizard is named the Create Publication Wizard. In SQL Server 2005, it is named the New Publication Wizard. For simplicity, it is referred to here as the Publication Wizard.

The easiest way to create a publication is to use the Publication Wizard in SQL Server. The wizard provides a graphical user interface that lets you select the Publisher, the publication type, and the articles to publish. It also lets you configure filtering for the publication.

When you create a publication for SQL Server Compact Edition Subscribers by using the Publication Wizard, you must select the following options:

  • On the Publication Type page, select Merge publication.
  • Enable Windows CE subscribers:
    • In SQL Server 2005, on the Subscriber Type page, select SQL Server Compact Edition.
    • In SQL Server 2000, on the Specify Subscriber Types page, select Devices running SQL Server Compact Edition.
    By enabling Windows CE subscribers, character mode snapshots are automatically configured for the publication. In SQL Server 2005, Web synchronization is also enabled.

If this is the first publication created for this server, the Publication Wizard prompts you to configure the default snapshot folder location. The snapshot folder holds the snapshot files that contain the schema and data for published tables. The IIS user must be able to read these snapshot files so that it can download the files to the smart device.

The snapshot folder default location is a local path in the installation folder for SQL Server. You must change this path to a shared folder so that the IIS user can access the snapshot from over the network. For more information about creating and configuring the snapshot folder, see Configuring the Snapshot Folder.

For more information about using the Publication Wizard, see "Replication Wizards" in SQL Server Books Online.

You can also create a new publication by using the sp_addmergepublication stored procedure. If you use the stored procedure, certain arguments must have specific values to permit SQL Server Compact Edition subscribers. The following table lists the arguments and their required values.

Argument Required Value SQL Server 2000 or SQL Server 2005












SQL Server 2000






SQL Server 2005 only


both or publisher

SQL Server 2005 only



SQL Server 2000 only

Besides the required arguments in the previous table, the following rules apply to additional arguments you can use with the sp_addmergepublication stored procedure:

  • @alt_snapshot_folder is only supported if @snapshot_in_defaultfolder is set to 'false'.
  • @pre-snapshot_script is ignored by SQL Server Compact Edition Subscribers.
  • @post_snapshot_script is ignored by SQL Server Compact Edition Subscribers.
  • @keep_partition_changes is a deprecated parameter in SQL Server 2005 and should not be used. Instead, set @use_partition_groups to 'true' to improve synchronization performance with filtered articles.
  • @allow_synctoalternate is ignored by SQL Server Compact Edition subscribers.
When @partition_options is set to 1, 2 or 3, then SQL Server Compact Edition cannot help protect against out-of-partition inserts. Therefore, during synchronization they are ignored by the publisher, but are not logged as a conflict or deleted at the subscriber causing divergence. The developer must protect out-of-partition inserts from occurring at the application layer.