Download the Visual Studio add-in for SQL Server Compact 3.5 and 4.0 from here
New in version 1.6:
- Launch the Toolbox directly from Server Explorer!
- "Script Database and Schema for SQL Azure" - creates a SQL Azure "friendly" script (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
- More strict in closing connections
- File filters for all files were broken
- Includes fixes from latest scripting engine (126.96.36.199)