Wednesday, July 21, 2010

SQL Server Compact 3.5 with SQL Server Management Studio

Microsoft SQL Server Compact is an embedded(able) database ideal for desktop, (hand-held) mobile devices and web clients. It is free to download (also free to deploy and redistribute) and comes in the form of just one code-free file. Its small foot print makes it easy to deploy it to a variety of device sizes and requires no administration. It also supports a subset of T-SQL and a rich set of data types. It can be used in creating desktop/web applications using Visual Studio 2008 and Visual Studio 2010. It also comes with a sample Northwind database. It is ideally suited to offline and occasionally connected clients.

 For using SQL Server Compact with Visual Studio please follow this link.

In this article "SQL Server Compact 3.5 with SQL Server Management Studio"  managing SQL Server Compact 3.5 from the SQL Server Management Studio which is installed with SQL Server 2008 R2 Nov-CTP (or R2 RTM) will be described. Alternately one could also use SSMS bundled with SQL Server Express 2008. Creating databases, tables, indexes and nested queries are also described.

No comments: Protection Status