SQL Server mobile/compact Edition Brief Introduction

In addition to SQL Server Express,sql server, there is a more lightweight version: The SQL Server Compact Edition, which is reminiscent of the Windows compact Edition (Windows CE).

This version of SQL Server has only 1. SDF Data files (is not the thought of access, SQLite such database), mainly for: desktop programs (that is, single-machine programs), mobile device programs (mobile phones, tablets), embedded programs, etc., the need for lightweight database scenarios.

I. opening/ creating a database

1. SQL Server 2005, create a new database connection in SSMs, select SQL Server Mobile, specify the file path;

2. SQL Server 2008/2008 R2, create a new database connection in SSMs, select the SQL Server Compact, specify a file path, such as;

3. Beginning with SQL Server 2012 , the SQL Server Compact is no longer supported in SSMS and is supported in Visual Studio, which is what some developers call localdb/in Visual Studio Local database.

See MSDN for details:

Visual Studio https://msdn.microsoft.com/en-us/library/bb546200 (v=vs.110). aspx

Visual Studio https://msdn.microsoft.com/en-us/library/vstudio/ms233763.aspx

two. feature Support

There is a lot of functionality, and the database objects are monotonous, such as all objects on a newly created SQL Server Compact instance:

1. Very few database objects , only support custom tables, do not support custom views/stored Procedures/functions/triggers and so on;

2. Data type is limited , for example: character type only supports nchar, NVARCHAR;

3. The basic SQL syntax is limited , for example: count (DISTINCT) is not supported, having a reference to multiple columns;

4. Advanced SQL syntax is almost unsupported, such as: CTE, APPLY, MERGE, and so on;

Refer to msdn:https://msdn.microsoft.com/en-us/library/bb896140 (v=sql.100). aspx for details

In summary: Recently the company inside of a small program, someone used, feel very light, if the database components not too many requirements, may wish to try.

SQL Server mobile/compact Edition Brief Introduction