Beginner's Guide to SQL Server Compact

This page contains resources to help developers get up to speed with SQL Server Compact. For additional resources see the Learning Resources page.

Product Documentation

Overview of SQL Server Compact
Describes the SQL Server Compact 3.5 components, architecture, and environment.
Working with SQL Server Compact
Lists the steps to set up a SQL Server Compact environment.
How-to Topics
Provides information about completing common SQL Server Compact 3.5 tasks.
Differences Between SQL Server Compact and SQL Server
Lists Transact-SQL commands, features, and data types supported by SQL Server Compact, compared with SQL Server 2005.

Samples & Downloads

SQL Compact data and schema script utility

This console app and SQL Server 2008 Management Studio add-in helps you better manage your SQL Compact development efforts. It allows you to script schema and data to a .sql file, which can be used in any context. It also scripts DML for use in SSMS scripts.

SQL Compact Command Line Tool

Administer SQL Compact databases directly from the command line, without having Visual Studio or SQL Server Management Studio installed. Only requires NetFx 2.0 and SQL Compact installed. Command line options similar to sqlcmd. Also runs any SQL Compact script files.

SQL Compact Bulk Insert Library

.NET Library for loading data fast (doing bulk inserts) into a SQL Server Compact database file. Attempts to mimic the SQLClient SqlBulkCopy API.

Beginner's Guide to SQL Server Compact

Product Documentation

Samples & Downloads

SQL Server Compact Pages

Related Links

Tools