SQL Server Compact edition

SQL Server Compact edition (Named as Everywhere edition during CTP 2005). With SQL Server Compact Edition, you can develop and deploy applications independent of SQL Server and of Visual Studio. For SQL Server Mobile edition , there was restrictions to use it independently. However, with SQL Server Compact Edition, this restriction has been removed.

Runtime : SQL Server Compact Edition contains the runtime bits that can be used to develop applications and to deploy applications on desktop computers and on Tablet PCs. SQL Server Compact Edition is a powerful yet lightweight relational database engine. SQL Server Compact Edition supports familiar SQL syntax. Additionally, SQL Server Compact Edition provides a development model and an API that are consistent with SQL Server.

Advantages/Features :

· Free to use and distribute

· Supports desktops and mobile devices

· Fully embeddable architecture

· No administration required

· Single file, code-free database format

· Support for ClickOnce, XCopy, MSI, CAB, and non-admin embedded installation options

· Supports all Microsoft Windows embedded, mobile, desktop, and server operating systems

· Supports a rich subset of Transact-SQL syntax and SQL Server data types

· Microsoft Visual Studio 2008 integration

· Supports ADO.NET, LINQ to SQL, LINQ to Entities, and the ADO.NET Entity Framework

· Supports multiple concurrent local connections

· Backup and restore SQL Server Compact databases with simple file copy operations

· Connect to your SQL Server Compact databases easily from both managed and unmanaged code by using the included ADO.NET Data Provider or the OLEDB Provider

· Rich subset of SQL Server data types and Transact-SQL including:

o JOINS and sub-queries

o Filters, grouping, aggregates, sorting


o BLOB/image data types

· Backup and restore SQL Server Compact databases with simple file copy operations

Security Features

After the necessary SQL Server Compact 3.5 systems are installed, you must configure the IIS security options before any data can be exchanged between clients and servers.

SQL Server Compact 3.5 can also use the Secure Sockets Layer (SSL) feature of IIS to encrypt data propagated between a device running SQL Server Compact 3.5 and a computer that is running SQL Server.


Comment please...

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s