Developer Tools

    Microsoft® Visual Studio Team System 2008 Database Edition GDR R2

    Select Language:
    Microsoft® Visual Studio Team System 2008 Database Edition GDR R2 implements support for SQL Server 2008.
    • Note:There are multiple files available for this download.Once you click on the "Download" button, you will be prompted to select the files you need.
      Version:

      RTM

      File Name:

      setup.exe

      Documentation.zip

      GDR_R2_Release_Notes.mht

      Readme.mht

      Date Published:

      4/21/2009

      File Size:

      6.2 MB

      14.3 MB

      209 KB

      285 KB

        In addition to providing support for SQL Server 2008 database projects, this release incorporates many previously released Power Tools as well as several new features. The new features include distinct Build and Deploy phases, Static Code Analysis and improved integration with SQL CLR projects.

        Database Edition no longer requires a Design Database. Therefore, it is no longer necessary to install an instance of SQL Express or SQL Server prior to using Database Edition.

        SQL Server Support

        • SQL Server 2008


          • All new data types:


            • Intrinsic (date, datetime2, datetimeoffset, time)

            • Built-in SQL CLR types (geography, geometry, hierarchyid)


          • New DML


            • Merge, table parameters, …



        • SQL Server Configuration Options


          • Server option settings will be verified prior to deployment or set during deployment
            Additional 1st Class Object Type Support

          • Rules, defaults, Asymmetric keys, symmetric keys, certificates, …



        Projects

        • Server Projects


          • Server objects and option settings may be implemented in a separate Server Project

          • This enables a team to define a standard a configuration for their SQL servers and reference it from their Database Projects


        • Partial projects


          • Allowing code sharing between projects by including files from a different project, where the code is included as-is from the originating project and the source code control ownership remains with the originating project

          • This enables code reuse and single sourcing while having a single deployment unit


        • Composite projects


          • References to other database projects or .dbschema files that contribute to the same deployment unit.

          • This enables the separation of development roles and responsibilities and composition of Databases using multiple projects.




        Single sourcing of external artifacts

        • SQL-CLR references allow the user to create a reference to a SQL-CLR project or SQL-CLR assembly. This automatically becomes an ASSEMBLY type in the Database Project



        Build and Deploy

        • The Build process now produces a separate portable schema output that is fed in to a redistributable deployment engine

        • A redistributable deployment engine. For example, to implement a setup application that deploys the Database Project.


        Refactoring

        • Preservation of Intent


          • Enables the deployment of refactoring changes as intended by the user (renames are deployed as renames not as drop/add statements for example)



        New Refactoring Operations

        • Wildcard Expansion

        • Move Schema

        • Fully Qualify

        • Extensibility point which enables the ability to develop and deploy custom refactoring types and targets


        Schema Compare

        • Now supports comparing Projects, Databases or dbschema files in any combination. For example, Project to Project, which has not been possible until now.

        • Object Type Filtering

        • Additional ignore filtering options


        T-SQL Static Code Analysis

        • Including the ability to develop and deploy custom rules


        Dependency Viewer

        • View the dependency relationship between objects in your schema


        Unit testing

        • Supports execution with other ADO.NET providers


        Data Generation

        • Design-time enhancements


          • Smaller .dgen file

          • Support for undo/redo

          • Foreign key replacement

          • Separation of population status into new display window


        • Runtime enhancements


          • By default uses SqlBulkCopy to populate target tables

          • Capability to register different outputs for generated data – i.e. generate to Excel or to file so you can use BCP to load

          • By registering a custom output we have the capability to execute scripts at different points during data generation (i.e. before start/after completion or before/after a table



        Extensibility

        • Data Generators

        • Statistical Data Distribution

        • Test Conditions

        • Static Code Analysis Rules

        • Refactoring Types

        • Refactoring Target

    • Supported Operating System

      Windows Server 2003 Service Pack 2, Windows Server 2003 Service Pack 2 x64 Edition, Windows Server 2008, Windows Server 2008 Datacenter, Windows Server 2008 Datacenter without Hyper-V, Windows Server 2008 Enterprise, Windows Server 2008 Enterprise without Hyper-V, Windows Server 2008 Standard, Windows Server 2008 Standard without Hyper-V, Windows Vista 64-bit Editions Service Pack 1, Windows Vista Service Pack 1, Windows XP Service Pack 2

        Requirements vary for different combinations of features within the Database Edition. 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


        Prerequisites:

        • Microsoft® Visual Studio Team System 2008 Database Edition SP1 (English) or Microsoft® Visual Studio Team System 2008 Suite SP1 (English)

        • Microsoft® Visual Studio 2008 Service Pack 1

      • Install
        Localized versions of the GDR for Visual Studio Team System 2008 Database Edition will be available in the same languages as Service Pack 1 for Visual Studio 2008 (SP1). Each language-specific version of Database Edition must be installed on a version of Visual Studio 2008 SP1 that is running the same language. For example, the French GDR for Database Edition must be installed on a French version of Visual Studio 2008 SP1. If you would like to install a non-English version of the GDR for Database Edition, replace “English” with your language choice in the following instructions.
        1. Install Microsoft® Visual Studio Team System 2008 Database Edition SP1 (English) or Microsoft® Visual Studio Team System 2008 Suite SP1 (English)
        2. Uninstall the Database Edition Power Tools if installed. To uninstall the Power Tools from the command line, use: msiexec /X {EA016DAB-E08A-46FB-BBF0-ED6EB8FD4671}
        3. Uninstall any previous version of the GDR for Database Edition. To uninstall a previous version of the GDR from the command line, use: msiexec /X {DDF197C6-4507-3A19-A4B5-0E17CC931370}
        4. Install Microsoft® Visual Studio 2008 Service Pack 1
        5. Install Visual Studio Team System 2008 Database Edition GDR by running the self-extracting executable SETUP.EXE.

        Multi-Language Install
        Visual Studio 2008 SP1 and GDR for Database Edition support the side-by-side installation of English and a non-English language. To install a non-English version of the GDR for Database Edition in addition to an English installation:
        1. Follow the installation instructions listed above for the English installation.
        2. Repeat the installation instructions listed above, replacing the English versions of Visual Studio 2008, Visual Studio 2008 SP1, and GDR for Database Edition with the localized versions that you would like to install.


        Uninstall
        1. Uninstall “Visual Studio Team System 2008 Database Edition GDR”.
        2. Open a Visual Studio 2008 Command Prompt with Elevated Privileges (Start / All Programs / Microsoft Visual Studio 2008 / Visual Studio Tools / Visual Studio Command Prompt.
        3. Execute the command
          C:\Program Files\Microsoft Visual Studio 9.0\DBPro\DBProRepair RestoreDBPro2008

    Popular downloads

    Loading your results, please wait...

    Free PC updates

    • Security patches
    • Software updates
    • Service packs
    • Hardware drivers

    Microsoft suggests

    Download Visual Studio Community 2013 for free.
    Download Visual Studio Community 2013 for free
    Everything you need to create great apps.
    Download now