Choose Between SQL Server 2005 Compact Edition & SQL-Server 2005 Express Edition

Well Microsoft has come up with really handy versions of SQl-Server. The choice of using one over the other is quite a wise decision that one should make. Here I would specify some features of SQL-Server CE and SQL-Server EE which should be considered while you make your choice between the two.

I would like to mention here that both these editions are free to download and deploy .

	SQL Server 2005 Compact Edition	SQL Server Express Edition
Reasons to use SQL Server Compact Edition:	When you want essential relational database functionality in a compact footprint Ideal for mobile and desktop applications, including occasionally-connected Embeddable in applications Free to download, develop, deploy, and redistribute	Ideal for small server deployments as well as desktop applications with more rich requirements such as full text search and powerful XML query processing. When you want a seamless upgrade to SQL Workgroup, Standard, and Enterprise editions Free to download, develop, deploy, and redistribute
Reasons not to use	When you want to run as a service When you need a multi-user database server When you need the full functionality of SQL Server	When the footprint and memory requirements need to be compact When you want to run in process When you want to target devices

You can get the complete document here.

---

Possibly related posts: (automatically generated)

• Updatable keyset-driven cursors on remote tables require a transaction with…
• Understanding SQL Server 2005 editions
• American server and free expansion coming to Darkfall early July