Configuring the SQL Server Environment for Replication

To exchange data with SQL Server, you must first install the software components required for use with Microsoft SQL Server 2005 Compact Edition (SQL Server Compact Edition). For more information, see Installing a Server Environment.

After you install the necessary components, you must configure the appropriate security and connectivity options before any data can be exchanged by using replication between SQL Server and SQL Server Compact Edition.

Steps to Configure SQL Server for Replication

1. Create a Publication. For more information, see Creating the Publication.
2. Set the database and publication access. For more information, see Securing the Publication.
3. Configure the snapshot folder. For more information, see Configuring the Snapshot Folder.

See Also

Concepts

Installing a Server Environment
Installation Summary
Subscribing to Publications (SQL Server Compact Edition)
Synchronizing Data (SQL Server Compact Edition)
Monitoring Replication (SQL Server Compact Edition)

Help and Information

Getting SQL Server Compact Edition Assistance