Click Here to Install Silverlight*
United StatesChange|All Microsoft Sites
Microsoft
Download Center 
Search Advanced Search

Microsoft® Visual Studio® 2005 Team Edition for Database Professionals Power Tools

Brief Description
The Microsoft Visual Studio 2005 Team Edition for Database Professionals Power Tools is a set of enhancements and tools that compliment and improve the user experience of Team Edition for Database Professionals

On This Page

Quick Details
File Name:VSDBProPT.msi
Version:2.0.50727.354
Date Published:8/13/2007
Language:English
Download Size:1.1 MB
Estimated Download Time: 3 min 56K

Overview

This release includes 5 new refactoring types, a new dependency viewer, additional data generators and editors, 2 new MSBuild tasks for Schema and Data Compare as well as the introduction of the TSQL Static Code Analysis feature

TSQL Static Code Analysis
• Static Code Analysis - A precursor to the functionality that will be in future versions of VSTS that will allow you to perform Static Code Analysis on T-SQL code.

Refactoring
• “Move Schema” Refactoring - Allows a user to right click on an object and move it to a different but existing schema
• SP Rename Generation - Generate a new script that will contain sp_renames for all rename refactored objects that the user can then execute.
• Wildcard Expansion - Automatically expand the wildcard in a select to the appropriate columns.
• Fully-Qualified Name Support - Automatically inject fully-qualified names when absent in a script
• Refactoring extended to Dataset - Refactor into strongly typed dataset definitions

MSBuild Tasks
• Data / Schema Compare Build Tasks - MSBuild tasks that can generate scripts as if the user had run the Data / Schema compare UI

Schema View
• API Access to Schema View - Insert / Update / Delete to schema View and list schema objects and their associated files

Dependency Tool Window
• Dependency Tree - Show the dependencies ( incoming / outgoing ) for selected schema objects in a new tool window

Miscellaneous Tools
• Script Preprocessor - Expand SQLCMD variables and include files and command line version (sqlspp.exe) & an MSBuild version ( wraps the command line version )

 Top of page

System Requirements

  • Supported Operating Systems: Windows 2000 Service Pack 4; Windows Server 2003 Service Pack 1; Windows Server 2003 x64 editions; Windows Vista; Windows XP Professional x64 Edition ; Windows XP Service Pack 2
Requirements vary for different combinations of features within Team Edition for Database Professionals. To install this product, we recommend:

• Computer with a 2.0 GHz processor
• 512 MB of RAM (1 gigabyte [GB] recommended)
• 3 GB of available hard-disk space
• DVD-ROM drive
• 1024x768 resolution with 256 colors
• Keyboard and mouse or compatible pointing device
• Visual Studio 2005 Professional with Service Pack 1 installed
• Visual Studio 2005 Team Edition for Database Professionals Service Release 1 installed
• An instance of SQL Server 2005 (Developer, Enterprise, Standard, Express, or Evaluation Edition)

 Top of page

Instructions

Note: You must install Visual Studio 2005 Professional with Service Pack 1 and Visual Studio 2005 Team Edition for Database Professionals Service Release 1 before you install the power tools for Team Edition for Database Professionals.

You can find documentation for Team Edition for Database Professionals as part of the online MSDN Library. In addition, you can install the documentation on your local computer from the December 2006 release of the MSDN Library.

 Top of page

Additional Information

You can find additional information about tools and samples for Team Edition for Database Professionals at http://www.codeplex.com/vsdbpro.

 Top of page

 Top of page

 Top of page


© 2009 Microsoft Corporation. All rights reserved. Contact Us |Terms of Use |Trademarks |Privacy Statement