Using MSDE 2000 with SQL Server CE RDA and Replication (303789)


The information in this article applies to:

  • Microsoft SQL Server 2000 Windows CE Edition 1.1
  • 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 "Introducing Replication Programming" 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.

REFERENCES

SQL Server Books Online
Modification Type:MinorLast Reviewed:9/20/2005
Keywords:kbinfo KB303789
©2004 Microsoft Corporation. All rights reserved.