Download the Visual Studio add-in for SQL Server Compact 3.5 and 4.0 from
hereNew in version 1.7:
- Now supports the "Visual Studio 2010 SP1 Tools for SQL Server Compact 4.0 CTP2" (ie Server Explorer connections to version 4 files)
- Data types node with documentation tooltips added
New in 1.6:
- Launch the Toolbox directly from Server Explorer!
- "Script Database and Schema for SQL Azure" - creates a SQL Azure "friendly" script (for example batching INSERTs and Primary Keys created before INSERTs)
- "Script Database Diff" (beta feature - please provide feedback) - scripts all objects that are different as CREATE or ALTER
Fixes:
- Primary keys were not listed under the Indexes node
- Own (non Server Explorer) version 4.0 connections have special icon