Power Tools Release: Script As, Grouping, Filtering

I’m pleased to announce the latest release of SSDT Power Tools. As noted previously we are using power tools to get early versions of experiences to you because we’re interested in hearing your feedback.  This release of the tools builds on the previous release.

Edit: SSDT Power Tools are no longer available the link above, but have been integrated into the core SSDT product in the December 2012 release (http://blogs.msdn.com/b/ssdt/archive/2012/12/13/available-today-ssdt-december-2012.aspx

What’s new?

Based on your feedback we have added “Script As…” in SQL Server Object Explorer (SSOX) to help you generate Create, Alter, Drop, and Drop and Create-To script from your connected databases.

Second, we added the ability to group by Schema, then by object type in Schema View:

Also, we added the ability to filter out built-in and external types in Schema View. Here’s the same database as above with Built-In objects hidden:


Additionally, we’ve made it easier to find the file for a specific object in your project. Now you can just right-click on the object in Schema View and choose “Select in Solution Explorer to be taken directly to the file containing your object.


Also, we added the ability to compare schema directly from Database nodes.


Installing and upgrading SSDT Power Tools:

This is designed for VS 2010 Integrated Shell and Pro + SKU with SSDT installed. If you haven’t already got SSDT, you can grab it for free on our site.

As updates to the Power Tools are released, you will need to uninstall the previous version of the Power Tools before installing the new one. You can do this from the Tools Menu. Click the “Extension Manager” option, then Click The “Uninstall” button.

This is due to a known issue in comparing the signatures of the extensions (http://support.microsoft.com/kb/2581019).

Send us feedback!

We’ve still got more goodies planned in this space including auto-refresh as Janet mentioned, but we want to hear what you think. Please let us know what you think via the “Q and A” tab of our gallery page or on our team forum.  We look forward to hearing from you!