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
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:
- On the Publication Type page, select Merge publication.
- On the SQL Server Compact Edition Subscribers page, select Yes.
- On the Articles page, select the tables you will publish. Only tables can be published to SQL Server Compact Edition subscribers.
- If you want to add a dynamic filter, on the Add Filter page, use the HOST_NAME() function in the filter statement.
Complete the wizard according to your needs.
See Also
Concepts
Publishing Data for SQL Server Compact Edition Subscribers
Using Merge Replication