Performance Zone is brought to you in partnership with:

Erik Ejlskov Jensen is a .NET Data Developer, and SQL Server Compact MVP. He is also the author of a number of tools for SQL Server Compact. He has been working in IT for too many years, and enjoy blogging (http://erikej.blogspot.com) and tweeting (@ErikEJ) Data Development related news and tips. Erik Ejlskov is a DZone MVB and is not an employee of DZone and has posted 58 posts at DZone. You can read more from them at their website. View Full User Profile

SQL Server Compact Toolbox 3.3–Visual Guide of new features

03.18.2013
| 1870 views |
  • submit to reddit

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


Published at DZone with permission of Erik Ejlskov Jensen, author and DZone MVB. (source)

(Note: Opinions expressed in this article and its replies are the opinions of their respective authors and not those of DZone, Inc.)