How to: Create a Publication for SQL Server Compact Edition Subscriptions (SQL Server Management Studio)

This topic provides the specific configuration details to consider when you create and configure a publication on Microsoft SQL Server 2005 for Microsoft SQL Server 2005 Compact Edition (SQL Server Compact Edition) Subscribers. To learn how to create a publication in SQL Server 2005, see "How to: Create a Publication and Define Articles (SQL Server Management Studio) in SQL Server 2005 Books Online.

To create a publication

1. Run the New Publication Wizard and follow the steps in "How to: Create a Publication and Define Articles (SQL Server Management Studio)" in SQL Server 2005 Books Online. As you move through the wizard, select the following options:

   1. On the Publication Type page, select Merge publication.
   2. On the SQL Server Compact Edition Subscribers page, select Yes.
   3. On the Articles page, select the tables you will publish. Only tables can be published to SQL Server Compact Edition subscribers.
   4. If you want to add a dynamic filter, on the Add Filter page, use the HOST_NAME() function in the filter statement.

2. Complete the wizard according to your needs.

See Also

Concepts

Publishing Data for SQL Server Compact Edition Subscribers
Using Merge Replication

Help and Information

Getting SQL Server Compact Edition Assistance