Friday, March 15, 2013

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:

clip_image002

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.

clip_image003

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.

clip_image004

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:

clip_image006

Improvements


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

1 comment:

Emmanuel Thevenot Beaufort said...

I've been using your tool since several months, and it has proven invaluable in my day to day development.
Thanks for this update and for your ongoing work.