SQL Server Compact Toolbox 3.3–Visual Guide of new features
After more than 170.000 downloads, version 3.3 of my SQL Server Compact Toolbox extension for Visual Studio 2012 and 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
New text editor
In this release, the text editor used for the SQL Query window has been updated to use the AvalonEdit text control. The new control features improved syntax colour highlighting, also available during editing. In addition, the editor also enables search (use the new Search button on the toolbar), with hit highlighting:
New Maintenance menu
In order to support the fact that the Server Explorer is no longer available for version 3.5 in Visual Studio 2012, I have now slowly begun adding features from the SQL Server Compact Server Explorer Tools. The first is the maintenance options: Shrink, Compact, Verify and Repair.
Reinitialize Merge Replication subscriptions
In addition to synchronizing Merge Replication subscriptions, it is now possible to re-initialize a subscription, meaning starting over with a new set of data from the server, but retaining any local data.
Script SQL Server data only
The SQL Server scripting menu items have moved to a scripting menu and the missing “Script SQL Server Database Data” option is now there:
- SQL Server export - improved handling of default values and identical table names in different schemas (but this is not yet fully supported)
- Less SmartAssembly prompts
- CSV import error fixed