Microsoft KB Archive/303789

= Using MSDE 2000 with SQL Server CE RDA and Replication =

Article ID: 303789

Article Last Modified on 2/22/2007

-

APPLIES TO


 * Microsoft SQL Server 2000 Windows CE Edition 1.1
 * Microsoft Encarta Interactive World Atlas 2001
 * Microsoft SQL Server 2000 Windows CE Edition

-



This article was previously published under Q303789



SUMMARY
Microsoft SQL Server 2000 Windows CE Edition (SQL Server CE) connectivity Remote Date Access (RDA) or replication is fully supported by Microsoft SQL Server 2000 Desktop Engine (MSDE 2000). This article answers several frequently asked questions regarding MSDE 2000.



MORE INFORMATION
Q1: Does SQL Server CE RDA or replication work with MSDE 2000?

A1: Yes, merge replication is supported by MSDE, except there are no built-in wizards, so replication must be configured manually.

Q2: Other than buying SQL Server 2000 Developer Edition for installing and deploying SQL Server CE, does the customer need to buy any SQL Server client access license (CAL) to deploy an RDA or replication solution based on MSDE 2000?

A2: No. Note, however, that MSDE has a limit of five concurrent workloads. Any additional concurrent workload will slow down the processing. Connecting to MSDE is possible for very small workload scenarios. SQL Server 2000 is suggested as the scalable backend database server.

However, if the SQL Server CE device connects to MSDE, which either forwards the data or extracts data from a SQL Server backend, then client access licensing or processor licensing is needed.

Client Access License Details on MSDE 2000 and SQL Server CE licensing are accessible from the following Microsoft Web page:

http://www.microsoft.com/sql/

Q3: How can I make it easier to program replication to work with MSDE 2000?

A3: The SQL Server Books Online topic &quot;Introducing Replication Programming&quot; says:

Microsoft® ActiveX® controls, when used within custom applications that employ Microsoft Visual Basic® or Microsoft Visual C++®, provide programmable controls for administering and controlling the Snapshot Agent, the Distribution Agent, and the Merge Agent. These controls can be used to program activities needed to operate replication. Using ActiveX replication controls, you can build custom applications to configure and administer replication.

Q4: Does SQL Server CE RDA or replication work with MSDE 1.0 (MSDE for Visual Studio 6.0)?

A4: SQL Server CE replication does not work with SQL Server 7.0 and earlier versions. (MSDE 1.0 is a SQL Server 7.0-compatible engine.)

SQL Server CE RDA has not been tested with MSDE 1.0 and is not supported.

