Erik Ejlskov Jensen is the author of the SQL Server Compact Toolbox add-in. SQL Server Compact Toolbox is a Visual Studio 2010 Pro or higher add-in (for 3.5/4.0) and standalone app (for 4.0), that adds scripting, import, export, migrate, rename, run script, manage replication and more to your SQL Server Compact Data Connections in VS Server Explorer.
If you are using SQL Server Compact in an application, you will find this add-in very helpful. You can connect to a database and explore the objects it contains, run queries, script both tables and the data they contain, import data, and migrate data between SQL Server Compact and SQL Server or SQL Azure.