This article compares the following products:
- Microsoft SQL Server 2005 Express Edition for Microsoft Office Outlook 2007 with Business Contact Manager
- Microsoft SQL Server 2000 Desktop Engine (MSDE 2000) for
older versions of Outlook with Business Contact Manager.
All versions of Outlook with Business Contact Manager use a stand-alone SQL Server service for primary data storage. Older versions of Outlook with Business Contact Manager use MSDE 2000. Outlook 2007 with Business Contact Manager uses the newer SQL Server 2005 Express Edition.
SQL Server 2005 Express Edition provides several advantages, such as larger database capacity. Additionally, multiple concurrent users can access the database without difficulty. The comparable features are outlined in the following table.Comparison of SQL Server 2005 Express Edition and MSDE 2000
Collapse this tableExpand this table
|SQL Server 2005 Express Edition||MSDE 2000|
|Includes User Instance support.||Does not include User Instance support.|
|Data Transformation Service (DTS) runtime is available in a separate download.||DTS runtime is present.|
| Easy deployment because Microsoft Data Access Components (MDAC) is not part of the installation.||MDAC is part of
|Uses Microsoft Windows Installer only. Has good servicing story.||Uses Windows Installer and MSM.
Servicing of MSM is difficult.|
|Transactional replication, merge replication, and snapshot subscriber replication are supported.|| Merge and snapshot publications are supported, in addition to
the replication subscription.|
| Robust setup user interface.||Basic setup user interface.|
| No agent is present.||Agent is present.|
| Supports Microsoft Windows 2000 SP4, Microsoft Windows XP SP1, and Microsoft Windows Server 2003.|| Supports Microsoft Windows 98, Microsoft Windows Millennium Edition, Windows 2000, Windows XP, Microsoft Windows
NT 4.0, and Windows Server 2003.|
|Common language runtime support.||No common language runtime support.|
|Graphical user interface (GUI) tools are available.||No GUI tools are available.|
| Database size limit: 4 GB||Database size limit: 2
| 1 CPU, 1 GB RAM||2 CPU, 2 GB RAM|
| No throttle * || Workload throttle is enforced for five concurrent workloads. |
| Deep integration with Microsoft Visual Studio.||Basic
integration with Visual Studio.|
* SQL Server 2005 Express Edition and SQL Server 2005 allow for multiple concurrent users to connect to the database. The number of concurrent users depends on the CPU and on the RAM on the computer that hosts the database.