Explore purchasing options
Visual Studio Team System 2008 Database Edition
Visual Studio Team System 2008 Database Edition provides advanced tools for database change management and testing and offers functionality to enable database developers and administrators to be more productive and increase application quality in the database tier.
Visual Studio Team System 2008 Database Edition delivers a market shifting database development product that provides a foundation for managed database evolution through the use of an offline, Visual Studio project-centered source code control system together with a suite of tools designed to help understand the impact of proposed changes. Schemas, DML and metadata can be versioned, code can be automatically reviewed using static analysis, unit tests can be created and executed to ensure quality, and comparisons can be made with test and production systems prior to deployment. Integration with Visual Studio Team System 2008 Team Foundation Server helps increase the productivity of the database professionals by enabling them to become an integral part of the application team.
Simplify database development
Simplify your database development with more comprehensive support for database refactoring.Gain insight into T-SQL code
Gain greater insight into your T-SQL code with enhancements that enable you to see dependencies, expand wildcards, and perform in-depth code analysis.Extend the Schema View
Customize and extend the Schema View with new, enhanced extensibility application programming interfaces.
What’s New in 2008
- T-SQL Static Code Analysis: Automatically review T-SQL code to help improve code quality and security.
- Dependency Tree: Visualize the dependencies (incoming/outgoing) for selected objects in a new tool window.
- Schema reporting: Easily document your database schema.
- Refactoring tools: Automatically update and generate new code for operations including moving schemas, expanding ‘select *’ SQL statements, and fully qualifying names in scripts.
- Data generator: Gain flexibility in generating data with new data generator and editors.
Feature Highlights
- Rename refactoring support for database objects
- Schema Compare to keep two schema versions synchronized
- Data Compare to keep the data in two databases synchronized
- Offline database projects for change isolation
- Extensible unit test functionality
- Data Generator to define sets of repeatable test data
- New designer enables users to create T-SQL with the same fidelity as managed code
