Offical team blog for SSDT, a tool for on and off-premise database development
SSDT for Visual Studio 2012: http://msdn.microsoft.com/en-us/jj650015
SSDT for Visual Studio 2010: http://msdn.microsoft.com/en-us/jj650014
We have received an overwhelming amount of feedback that database unit testing is a critical feature for customers, so SSDT- December 2012 adds support for this feature. Database Unit Testing in SSDT will look familiar to many of you as it is based on the equivalent capability in the Visual Studio 2010 DB Pro tools. Some highlights:
Stay tuned for a follow-up post on getting started with SQL Server database unit testing.
The SSDT team started releasing SSDT Power Tools last April as a mechanism to deliver new and experimental features with each release. Since then, the Power Tools have been downloaded over 24,500 times.
We received a great deal of positive feedback on the Power Tools and as a response, this release integrates the functionality previously delivered via Power Tools into the core SSDT product. The advantage of product inclusion is that a separate install will no longer be needed and that features are now fully supported and available to users in all languages. The following features are now included in SSDT's SQL Server Object Explorer:
Projects node adds the equivalent of Schema View to SSDT. You can use this node to browse the logical schema of your project and to edit, refactor, and add new objects.
Script As support in SSOX enables you to generate Create, Alter, Drop, and Drop and Create-To scripts for objects in your connected database.
DAC actions allow you to perform similar DAC-based tasks in SSDT to those available in SSMS. You can extract a dacpac from a live database, publish a dacpac to a database, register a database as a DAC, or remove the registration metadata for a database registered as a DAC. These actions are supported for both on-premises SQL Server databases as well as Windows Azure SQL Databases.
We recommend that you uninstall the SSDT Power Tools extension if you had it previously installed.
This release includes the November 2012 release of SQL Server Data-Tier Application Framework (DACFx), which contains several feature enhancements and bug fixes. You can learn more about the latest release of DACFx here.
SSDT - December 2012 contains over 50 bug fixes, including fixes for customer-reported issues from SSDT - November 2012 and SSDT Power Tools releases.
If you have any questions or feedback about SSDT, please visit our forum or Microsoft Connect page. We look forward to hearing from you.
Thanks @Janet. Missed that.
Thanks for adding the Script As functionality. I've found that useful in the past in SSMS.
Has anyone tried Unit testing.. I got VS 2012 Ultimate + Update 1. SSDT version 11.1.21208.0. Still dont see options to create Unit tests.. Am I using right version of tools required?
@Sahaswaranamam Did you look at SQL Server Object Explorer and go to the Projects folder? For one of your database projects found there, drill-down to the Stored Procedures folder and right-click on an SP. It should be the first menu item; "Create Unit Tests..."
Found it.. Thanks !!
Can I find a list of the bug fixes anywhere? Specifically, I'm looking for enhancement with compare scripts picking up column extended properties for functions. (In line or multi-statement).
Too bad this crap still doesn't allow me to open my RPTPROJ projects. Lazy, coding IMO... inexcusable... useless
I can't use the safe refactor, rename in SSDT Visual Basic 2010 and 2012. What should I do to enable the safe refactor?
When I update a stored procedure with SSDT, it generates a script that disables all DDL triggers and re-enables them afterwards. We use DDL triggers to track SP changes, so is there a way to have the update scripts omit the DDL disabling part?
Specifies whether Data Definition Language (DDL) triggers are disabled at
the beginning of the publish process and re-enabled at the end of the
Setting this to false should be getting you want you want. In general the MSDN forum are probably a better place where you will get more reliable and quicker answers instead of the blog comments. social.msdn.microsoft.com/.../threads
Thanks very much. But where do I configure this when using the object explorer without a database project, i.e. where to put this config option..?
Nice to see the database unit tests back in place. For the next release, please please please bring back the test data generator!
So far the latest release is working great for us, using it on a BI project right now. I concur with Konamiman, the Data Generation will be a big win for me and my clients.
On a side note, that is a cool color scheme used in the screen shots. Is that theme available for download anywhere?
Data Gen is on the team's radar-- thanks for the feedback. @Robert the screenshots are using the dark theme that VS 2012 ships with.
I am doing a Scheme Compare with a dacpac as the Source and a SQL database as the target.
The differences are shown correctly but the generate script button and Update buttons are disabled.
Thus, I'm unable to update the database with the schema changes......is this a known issue or have I missed something?