SQL Server Data Tools

Announcements

• First Release of SSDT Power Tools

  Janet YeildingMicrosoft EmployeeTuesday, April 03, 2012 5:23 PM

  From http://blogs.msdn.com/b/ssdt/archive/2012/04/02/first-release-of-ssdt-power-tools.aspx

  I am pleased to announce the first release of SSDT Power Tools.The SSDT team will be leveraging Power Tools as a mechanism to deliver new functionality and experiences through frequent updates, of which this is the first example. In this first iteration, we focused on addressing the feedback that SSDT does not offer the equivalent of the Schema View tool window found in the Visual Studio 2010 Database Project. This release of the SSDT Power Tools will add the Schema View capabilities back by extending the SQL Server Object Explorer, providing a logical view over the schema hosted inside your projects.

  What can it do?

  After the Power Tools are installed, you'll notice a new node named “Projects” inside the SQL Server Object Explorer. You can use this tree to navigate your schema, edit objects, refactor them, and add new objects. 

  
  

  What's next?

  There are several features in the Visual Studio 2010 Schema View version that are not included in this release:

  • Group by Schema: The tool only has top-level folders for object types. We plan on adding the option to the SQL Server Object Explorer in general, in order to group objects by schema, then object type

  • Filtering Built-In Objects and External Objects: Checkboxes to filter out built-in and external objects from the tree

  • Auto-refresh: Detect drift from project and refresh the tree automatically.

  We plan on addressing these features to complete the experience in a future update.

  Send us feedback!

  We're actively prioritizing our plans and adding new ideas based on your suggestions and feedback.  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!

• Available Today: SSDT RTW

  Janet YeildingMicrosoft EmployeeTuesday, March 06, 2012 5:17 PM

  We are pleased to announce that the first production release of SQL Server Data Tools (SSDT) is now available for download.  This release of SSDT represents an important step towards our continued investment and commitment to providing first class tooling for database developers on the SQL Server and SQL Azure platform. More than 85,000 people downloaded the SSDT Community Technology Previews to date and have been providing tremendous amounts of valuable feedback. The SSDT team would like to thank you!

  Download SSDT today and learn more about the product on our website.   If you have any questions or feedback, please visit our forum or Microsoft Connect page.  We look forward to hearing from you.

  (from http://blogs.msdn.com/b/ssdt/archive/2012/03/05/available-today-sql-server-data-tools-rtw.aspx)

• SQL Server Developers Tools code-named “Juneau” becomes SQL Server Data Tools (SSDT)

  Gert DrapersMicrosoft EmployeeMonday, October 17, 2011 9:02 PM

  Last week at the SQL PASS SUMMIT 2011 in Seattle, Ted Kummert announced during his keynote that the final name of SQL Server Developers Tools code-named “Juneau” will be SQL Server Data Tools or SSDT for short. Additionally, the final name for SQL Server “Denali” will be SQL Server 2012.

  Besides the final name there were other important data points shared at the PASS Summit regarding SSDT:

  • SSDT will be a broadly available as a free component of the SQL Server platform and will be available for all SQL Server users.
    • SSDT targets: SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012 and SQL Azure
    • SSDT will update with releases of SQL Azure, which means every 4-6 months
  • SSDT will be initially released with SQL Server 2012
    • SSDT with SQL Server 2012 will be hosted in the Visual Studio 2010 SP1 shell. It will install standalone or combine with existing Visual Studio 2010 Professional SP1 or higher installations
  • SSDT will also ship with the next major release of Visual Studio
    • In the next major Visual Studio release, SSDT will both replace and provide conversion capability for existing Visual Studio database projects
    • You can preview this change in the Microsoft® Visual Studio® 11 Developer Preview which was released at the //Build conference in September 2011
  • SSDT full versions and updates will be available online using the Web Platform Installer (WebPI)
    • SSDT installation will provide an administrative install experience to create a sharable setup which could be placed on a USB thumb drive or internal file share behind your firewall

  For more information, check out the slides from our PASS Summit breakout session Database Development with SQL Server Data Tools Code-Named “Project Juneau” [AD-213-M].

  So when can you get it?

  Well you have to wait till SQL Server 2012 is released. The good news is that you can check out CTP3 today and we will provide updated bits in Q4 of CY2011 for you to evaluate. Watch the SSDT MSDN forum and the team blog for more details in the coming weeks.

  Thanks,
  Gert Drapers (@DataDude)
  Principal Group Program Manager
  SQL Server Data Tools (#SQLDataTools)

  http://msdn.microsoft.com/data/tools

  Also posted at:
  http://blogs.msdn.com/b/gertd/archive/2011/10/17/sql-server-developers-tools-code-named-juneau-becomes-sql-server-data-tools-ssdt.aspx

   

• September 2011 MSDN Article on 'Juneau' Database Projects

  Barclay HillMicrosoft EmployeeWednesday, September 07, 2011 5:21 AM

  	With the new Database Project in the latest version of SQL Server Developer Tools, you can now perform your database development in the same environment as your application development. We introduce the new release. Jamie Laflen and Barclay Hill