Today’s post comes from Guest Blogger Erik Ejlskov Jensen, SQL Server Compact MVP, @ErikEJ
Toolbox for SQL Server Compact developers
If you use SQL Server Compact, Microsoft’s embedded database for devices, desktops and soon ASP.NET, this extension is for you.
It adds several features not found in Server Explorer Data Connections:
To start using the add-in, go to Tools, and select SQL Server Compact Toolbox:
The add-in will list any version 3.5 database connections, which you have defined in Server Explorer. For 4.0 (which is currently not supported in Server Explorer, but will be so in VS 2010 SP1), you can add a connection from the context menu (or even create an empty 4.0 database file):
To refresh the listed connections, click the refresh button on the add-in toolbar.
To create a SQL script file with all object definitions and data in your SQL Server Compact database (for documentation, backup or migration use), select “Script database schema and data” from the context menu:
To find out if you are missing indexes in your database, you can examine the graphical estimated query plan.
With the SQL editor open, press Estimated Plan:
It looks like an index is used here, which is a “good thing”.
From the database context menu, select “Create Database Graph (DGML)”
This will allow you to explore an interactive graph of your database tables, relationships, and columns:
You can submit feedback/patches, request features and browse/download the source code at the CodePlex site: http://sqlcetoolbox.codeplex.com – and keep up to date with the latest SQL Server Compact news on my blog: Everything SQL Server Compact
Have you written an extension? Want to see it featured here? Let me know!