How to: Synchronize a Subscription (SQL Server Management Studio)

In this topic, you will learn how to synchronize a Microsoft SQL Server Compact 3.5 (SQL Server Compact 3.5) subscription from within SQL Server Management Studio.

  1. In Management Studio, open Object Explorer.

  2. In Object Explorer, click Connect, and then choose SQL Server Compact 3.5.

  3. In the Connect to Server dialog box, choose the SQL Server Compact 3.5 database that you want to synchronize, and then click Connect.

  4. In Object Explorer, expand the SQL Server Compact 3.5 database, expand Replication, and then expand Subscriptions.

  5. Right-click the subscription you want to synchronize and choose Synchronize Subscription.

  6. In the Synchronize Subscription dialog box, provide a password, if it is required. You can also choose to reinitialize the subscription. If you choose this option, you must choose to either save or discard subscriber changes.

  7. Click OK to start synchronization.