SQL Server Compact 3.5 System Requirements
Published: December 15, 2006
On This Page
The following table lists the hardware and software requirements for the three SQL Server Compact environments: development, client, and server. For more information about the different environments, see SQL Server Compact Architecture and Installing SQL Server Compact.
|
Development environment | | • | Microsoft Visual Studio 2008 or later. | | • | Microsoft Internet Explorer 6.0 or later versions. | | • | Microsoft ActiveSync 4.0 or later versions |
|
Client environment | Desktop and Tablet PC platforms: | • | Windows Vista Home Basic | | • | Windows Vista Home Premium | | • | Windows Vista Business | | • | Windows Vista Enterprise | | • | Windows Vista Ultimate | | • | Microsoft Windows XP Professional SP2 | | • | Microsoft Windows XP Home Edition SP2 | | • | Microsoft Windows XP Media Center Edition 2002 SP2 | | • | Microsoft Windows XP Media Center Edition 2004 SP2 | | • | Microsoft Windows XP Media Center Edition 2005 | | • | Microsoft Windows XP Tablet PC Edition SP2 | | • | Microsoft Windows XP Embedded SP2 | | • | Microsoft Windows Server 2003, Standard Edition SP1 | | • | Microsoft Windows Server 2003, Enterprise Edition SP1 | | • | Microsoft Windows Server 2003, Datacenter Edition SP1 | | • | Microsoft Windows Server 2003 R2, Standard Edition | | • | Microsoft Windows Server 2003 R2, Enterprise Edition | | • | Microsoft Windows Server 2003 R2, Datacenter Edition |
Mobile device platforms: | • | Microsoft Windows CE 4.2 | | • | Microsoft Windows CE 5.0 | | • | Microsoft Windows CE 6.0 | | • | Windows Mobile 2003 Software for Pocket PC | | • | Windows Mobile 5.0 | | • | Windows Mobile 6.0 |
Note: Between 2 MB and 3 MB of available storage space required, depending on processor type and components installed. |
Server environment | | • | SQL Server 2005 or later versions of SQL Server 2005 | | • | Intel or compatible Pentium 600 MHz or faster processor (recommended processor speed is 1 GHz or faster), 256 MB RAM minimum (recommended RAM 512 MB or more), hard disk space 250 MB | | • | IIS 5.x or later versions Supported on 32-bit versions of Windows Server 2003, Windows 2000 SP4 or later versions, and Windows XP. 120 MB of available disk space on the server | | • | Microsoft ActiveSync 4.0 or later versions | | • | Microsoft Internet Explorer 6.0 or later versions |
|
1 Server environment can be set up on either one computer (single server environment) or multiple computers (multiple server environment). For more information, see Installing a Server Environment.
SQL Server Replication Components Requirements
In a multiple-server environment, to exchange data between SQL Server Compact Edition and SQL Server, you have to install replication components on the computer that is running IIS. The following table lists how to install the replication components on two different versions of SQL Server.
SQL Server 2005 and later versions | Install the SQL Server 2005 replication components from the SQL Server 2005 product CD. |
