Version 2.0 of my SQL Server Compact Toolbox extension for Visual Studio 2010 is now available for download. This blog post is a visual guide to the new features included in this release, many suggested by users of the tool via the CodePlex issue tracker.
Full support for SQL Server Compact 4 and the Visual Studio 2010 SP1 Tools for SQL Server Compact 4
The list of databases in the toolbox is now pulled from three sources, Server Explorer connections to 3.5 databases, Server Explorer connections to 4.0 databases, via the new Server Tools for VS 2010 SP1, and finally your own 4.0 connections (VS 2010 SP1 not required).
Your “own” connections are indicated with a + sign next to the database icon. In addition, the engine version is displayed.
SQL Editor improvements
The SQL Editor has been enhanced with the following new features:
– Added colored syntax to editor text
– Actual plan button added to editor toolbar
– Query duration added to editor status bar
– Runtime version added to editor status bar
Upgrade to version 4.0 format
An option to upgrade a 3.x database file to version 4 has been added to the “Add SQL Server Compact 4.0 Connection” dialog. More information about the Upgrade api here.
SQL Compact File Version checker
A SQL Server Compact version detection function has been added, to allow you to determine if a given file is version 2, 3.0/3.1, 3,5 or 4.0 database format.
All available SQL Server Compact data types listed
A Data types node with documentation tooltips has been added to the Toolbox tree view.
Enhanced About dialog
About dialog with more detailed SQL Server Compact status information, listing the exact runtime version of the ADO.NET provider in the GAC and detecting if the associated DbProvider is properly registered in machine.config.
As always, please provide feedback, suggestions and reviews at the CodePlex site: http://sqlcetoolbox.codeplex.com