SQL Server SQL Server 2005 Mobile Edition is the successor to Microsoft SQL Server Windows CE Edition (SQL Server CE) version 2.0. Both versions are powerful tools that make it easy to develop mobile applications by supporting familiar Structured Query Language (SQL) syntax and by providing a development model and API consistent with SQL Server. The database engine exposes an essential set of relational database features, such as an optimizing query processor and support for transactions and assorted data types, while maintaining a compact footprint that preserves precious system resources. Remote data access and merge replication ensure that data from SQL Server databases is delivered reliably; can be manipulated offline; and can be synchronized later to the server, making SQL Server Mobile and SQL Server CE ideal for mobile and wireless environments. Both versions are designed to integrate with the .NET Compact Framework through Visual Studio, simplifying database application development for devices. By using the SQL Server CE or SQL Server Mobile Edition data provider to manage code by means of the common language runtime, mobile application developers can build highly extensible applications with offline data management capability for disconnected scenarios. You should use SQL Server CE or SQL Server Mobile Edition as a complement to your development tools when: Extending enterprise data management capabilities to Windows Mobile–based devices. Developing applications that store and manipulate significant amounts of data on a mobile device. Needing reliable data replication with mobile devices in environments with intermittent connectivity. Figure 2 – Dialog box to create a new SQL Server Database in Visual Studio Team System. Figure 1 – Right-click to create a new SQL Server Database in Visual Studio Team System.