Database Project for Lab Management

Document Sample
Database Project for Lab Management Powered By Docstoc
					DEV217
Introducing Visual Studio Team
Edition for Database
Professionals

Thomas Murphy           Matt Nunn
tmurphy@microsoft.com   mattnunn@microsoft.com
Group Program Manager   Sr. Product Manager
Microsoft Corporation   Microsoft Corporation
Agenda

 Managing Database Change
   Where is the Truth?
   Team System Data Core Scenario
 Projects and Data Generation
 Ensuring Change - Testing
 Making Managed Change
 Build and Deploy
 Q&A
Other Sessions

 Introducing Visual Studio Team Edition for Database
 Professionals
   DEV217 - 6/13/2006 10:15AM - 11:30AM, room: 104 ABC
 Managing and Deploying your SQL Server Schemas with
 Visual Studio Team Edition for Database Professionals
   DAT312 - 6/13/2006 1:00PM - 2:15PM, room: 156 ABC
 Testing & Refactoring your Database with Visual Studio
 Team Edition for Database Professionals
   DAT320 - 6/14/2006 8:30AM - 9:45AM, room: 160 ABC
 Under the Hood of Visual Studio Team Edition for
 Database Professionals
   DAT433 - 6/15/2006 1:00PM - 2:15PM, room: 160 ABC
 Hands on Labs – 4 labs to use the product
 Focus Groups – sign-up at our Booth
Visual Studio Team System




               Developer




                            Visual Studio
                            • Productivity
                            • Powerful
                            • Ease of use
                            • World class IDE
                            • Broad reach
Visual Studio Team System




                   Architect                            Tester



                                       Developer

                                                   Project
                                   Designer        Manager


    VS Team System
    • Expand to development team
    • Business results from IT
    • Team productivity and
      collaboration
    • Integrated quality
Visual Studio Team System

                                         CIO
       PMO




             Architect                              Tester



                             Developer

                                               Project
                         Designer              Manager


                                                         Application
      Business
                                                          Support
       Analyst

                            Operations
Visual Studio Team System

                                            CIO
       PMO




                         Team Edition for
             Architect
                          Database Professionals
                                           Tester
                         • Expand to database teams
                         • Manage Database Change
                         • Extend Team productivity and
                                Developer
                           collaboration
                         • Integrated quality
                                                  Project
                  DB Pro Designer
                                                  Manager


                                                            Application
      Business
                                                             Support
       Analyst

                             Operations
What we heard from customers
or “why did we build it…”
  Managing Database Change is hard….
     A Rollback means a LONG night.
     Development Teams can end up working with out of
     date versions
       Loss of revenue because the release wasn’t synchronized
     Finding errors at the end of the development cycle
       More costly than finding them early
     Increased support cost when you break an application
     from a database update
  Disconnect between development and database
  teams
     Need to be more integrated
Incorporate the Database Professional into the software lifecycle and provide them
       with a foundation for change management and process integration.

   Change Management
       Project Based Development
           Project Model that represents schema as objects providing a “personal sandbox” for offline development that
           lives within a Visual Studio Solution
           Team Collaboration with Work Item and Process Integration with Team Foundation Server
       Automated Change Support
           Rename Refactoring with the ability to preview pending changes prior to execution
           Comparison Tools (Schema & Data Compare) allow comparisons & synchronization of schema and data
           with design/test/production databases
           Source/Version Control of all database objects with the ability to reverse engineer a database to bring it
           under Source Control
       Database Unit Testing
           Leverages the Test Project Infrastructure
           Generate “Real and Meaningful” Data Values through the ability to import information such as Row Counts
           and histograms from a real database
           Data Generator provides Repetitive Dataset Generation for tests based on saved settings
   Build / Deployment
       MSBuild Integration for Database Deployments/Builds based on Projects
       Either Create a new Database at the target location or Update an Existing Schema
Conceptual Overview
                            Production   Management
                             Database      Studio Tuning
 Difficult to Manage                                Monitoring
 Change to the schema
 Production Database is                    Schema Changes

 one version of the truth   Schema       “One Version of the
 for Data and Schema                     Truth” for Data
                                         and Schema
 DBA doesn’t have
 access to changes until
 he/she has deploy or
 reject choice
 Changes often made to
 production database
 and not rolled back into
 test
Conceptual Overview
  Schema Change now managed in          Production      Management
  VSTS and TFS                           Database         Studio Tuning
  Production Database is now “One                                    Monitoring
  version of the truth” only for Data
  DBA doesn’t have access to
  changes until he/she has deploy
  or reject choice
  “One Version of the truth for                         “One Version of the
  Schema” is Under Source Control                       Truth” for Data


                                                     Changes can be rolled out in
                        “One Version of the Truth”   a scheduled, managed way
                        for Schema                   Scripts allow administrators
                         • Offline                   to mange change updates
                         • Under Source Control


     Schema

  Schema Changes
           Visual Studio Team System
                                                                                                                 New!
                                                        Visual Studio Team Suite
                                         Software             Software             Software            Database
                            Visual       Architects          Developers             Testers          Professionals        Visual
                            Studio                                                                                        Studio
                            Team          Application        Code Analysis         Performance           Database        Industry
                           Explorer        Modeling                                  Testing              Change         Partners
                                                                                                       Management
MSF Process and Guidance




                                       Infrastructure and     Performance         Manual Testing      Database Testing
                                           Deployment            Tuning
                                            Modeling
                                                                                    Test Case        Database Build &
                                                            Security Analysis      Management          Deployment
                                                                                    Unit Testing

                                                                       Code Coverage
                                                                           Class
                                                                         Modeling
                                                                 Visio and UML Modeling
                                                                  Visual Studio Professional
                                                                            Edition

                                                                                  Load Test Agent



                                  Visual Studio Team Foundation Server
                                      Change Management            Reporting             Integration Services

                                      Work Item Tracking           Project Site          Project Management
Team Foundation Server
Mitigating project risks




Single data repository      Real-time reports      Process management
  offers true insight    for real-time decisions   minimizes variability
 Walkthrough Scenario




                                                                     T E A M D B D E V E L O P M E N T W I T H DB PRO
 “Managed Database Evolution for Northwind Traders”




                       Writes Tests
Creates New DB         Writes DB Code
Project
                       Refactors
Reverse Engineers DB
to Project             Runs Tests
                                             Reviews Changes
Creates Data           Checks In
Generation Plan                              Compares Updates to
                                             Production
                                             Builds Deploy Package
                                             Deploys to Production


        Manage            Develop            Deploy

             DBA              DB DEVELOPER       DBA
Database Projects
Creating a Baseline
Creating a Project

 Core concept: off-line database development
 Simply a series of files collected together into a
 single logical collection
 The files represent the truth of your schema
 Can be included in complete solution
 Connects to SCCI providers for versioning such
 as Team Foundation Server
 For Additional Details See DAT312
Off-line Development                    Production
                                         Database
 Import database schema to populate
         Create table AUCTION
 project from existing database
         ( id int not null,
         title varchar(25) not null,

 Changes to schema traditionally have
         startDate DateTime not null,
         length in not null)

 immediate affect
 With off-line project nothing changes
 until you deploy the change
                                           Test
                                         Database
Test Data

 To create a solid foundation for testing we
 support data generation
 Deterministic – always generate the same layout
 Matched to your schema and very customizable
 Extensible mechanism, build your own
 generators
 Will support histograms and distributions in final
 release

 Feature: DataGenerator
The Project System and Import
Database Schema
Ensure Stability
Testing your System
A Rollback Means a LONG Night

 Unit Testing helps ensure that changes do not
 break existing code
 Unit test designer is SQL focused
   Work in the language of your choice: TSQL, VB, C#
 Builds on existing Team Test Unit Test
 functionality
 For Additional Details see DAT320
What We Can Test

 Stored Procedures
 Functions
 Triggers
 Arbitrary SQL
 Support at RTM to automatically deploy changes
 to test system and generate data
 Deterministic data generation ensures stable test
 state
 Can test with your application tier because of
 common framework
Ensure Change with a Test
Foundation
Managed Change
Controlling what happens
Managed Change

 Changes are local to project
 Project can be compared with database
 All elements can be managed under version
 control
  Any SCCI compliant version system
 Template driven
  Version specific SQL 2000 or SQL 2005
Working With the Project

 Add new elements
 Modify existing elements
 Delete Items
 Deploy new or incremental update
Refactoring

 Bring power of refactoring to SQL
   Cascading Change
 Update all dependent objects in database project
   Schema objects, Data generation, Unit Tests, SQL
   Scripts
 Make an atomic change, see preview
 Rename
   Meet corporate standards
   Better express semantic intent – clarity
 For Additional Details in DAT320
Making Changes
Safely Deploy
Managing Updates
Build/Deploy

 Standard VS build task
 Configurations
   New vs. Update builds
   Project properties for build
   Schema compare used for build
 Pre/Post Deployment scripts
 Build results in SQL script file
 Deploy
   Deploy via SQL query tool
   Deploy via MSBuild task
   RTM: SQLCMD command support
 For Details Attend DAT312
Build and Deploy
Pricing, Licensing and Availability

  Included in Team Suite at No Extra Cost
  Purchase as an individual Edition
    Same pricing as other Team System Editions
       Retail Price - $5469
       Many Discounts available
       http://msdn.microsoft.com/vstudio/howtobuy/default.aspx
  Availability
    CTP 3 Available Today
       Pick up a copy in the Blue TLC Area
       http://msdn.microsoft.com/vstudio/teamsystem/products/dbpro
       /
    RTM By the end of 2006
Wrap Up

 Managed, project oriented evolution of database
 schema – no more rollbacks
 Go get the CTP at our booth and try it out on
 your databases
   http://msdn.microsoft.com/
 Report feedback (good & bad)
   http://forums.microsoft.com/MSDN/ShowForum.aspx?
   ForumID=725&SiteID=1
 Further Questions:
   Thomas: tmurphy@microsoft.com
   Matt: matt.nunn@microsoft.com
Other Sessions

 Managing and Deploying your SQL Server
 Schemas with Visual Studio Team Edition for
 Database Professionals
   DAT312 - 6/13/2006 1:00PM - 2:15PM, room: 156
   ABC
 Testing & Refactoring your Database with Visual
 Studio Team Edition for Database Professionals
   DAT320 - 6/14/2006 8:30AM - 9:45AM, room: 160
   ABC
 Under the Hood of Visual Studio Team Edition
 for Database Professionals
   DAT433 - 6/15/2006 1:00PM - 2:15PM, room: 160
   ABC
VSTE DB Pro ChalkTalks
 DATLC10: Q&A: Managing and Deploying Your SQL Server Schemas with
 Visual Studio Team Edition for Database Professionals
 Tuesday, June 13, 4:30 PM - 5:45 PM
 Richard Waymire; Mairead O'Donovan
 DATLC16: Q&A: Testing and Refactoring Your Database with Visual Studio
 Team Edition for Database Professionals
 Thursday, June 15, 8:00AM – 9:15AM
 Gert Drapers; Sachin Rekhi
 DEVTLC17: Q&A: Visual Studio Team Edition for Database Professionals:
 Overview
 Thursday, June 15 9:45 AM - 11:00 AM
 The Team Data Team
 DATLC20: Q&A: Under the Hood of Visual Studio Team Edition for
 Database Professionals
 Thursday, June 15, 4:30 PM - 5:45 PM
 Gert Drapers
VSTS DB Pro HOLs

 DEV008: Version Controlling your SQL Server
 Database Schema with Visual Studio Team
 Edition for Database Professionals
 DAT006: Managing Change to your SQL Server
 Database Schema with Visual Studio Team
 Edition for Database Professionals
 DEV024: Understanding Team Integration with
 Visual Studio Team Edition for Database
 Professionals
 DAT015: Build and Deploy you SQL Server
 Database Schema with Visual Studio Team
 Edition for Database Professionals
VSTS Breakout Sessions
 DEV304 - Delving into Visual Studio 2005 Team Edition for Software Architects
       6/12/2006 10:45AM-12:00PM 160ABC
 DEV307 - Delving into Visual Studio 2005 Team Edition for Software Developers
       6/12/2006 1:30PM-2:45PM Grand Ballroom A
 DEV311 - Delving into Visual Studio 2005 Team Edition for Software Testers
       6/12/2006 5:00PM-6:15PM 104 ABC
 DEV217 - Introducing Visual Studio 2005 Team Edition for Database Professionals
       6/13/2006 10:15AM-11:30AM 104 ABC
 DAT312 - Managing and Deploying Your SQL Server Schemas with Visual Studio Team Edition for Database
 Professionals
       6/13/2006 1:00PM-2:15PM 156 ABC
 DAT320 - Testing and Refactoring Your Database with Visual Studio Team Edition for Database
 Professionals
       6/14/2006 8:30AM-9:45AM 160 ABC
 DEV327 - Visual Studio 2005 Team Foundation Server (Part 1): Applying Version Control, Work Item Tracking
 and Team Build to Your Software Development Project
       6/14/2006 10:15AM-11:30AM 160 ABC
 DEV429 - Visual Studio 2005 Team Foundation Server (Part 2): Developing Custom Process Templates, Work
 Item Types and Policies
       6/14/2006 2:00PM-3:15PM 160 ABC
 DEV233 - Visual Studio 2005 Team Foundation Server: Using Metrics to Manage and Troubleshoot Your
 Projects
       6/14/2006 5:30PM-6:45PM 153 ABC
 DEV237 - Visual Studio 2005 Team Foundation Server: Step-by-Step Migration and Adoption Planning
       6/15/2006 9:45AM-11:00AM 104 ABC
 DEV439- Visual Studio 2005 Team System and Microsoft Solution Framework: Implementing an Agile or
 CMMI Process
       6/15/2006 1:00PM-2:15PM 156 ABC
 DAT433Under the Hood of Visual Studio Team Edition for Database Professionals 6/15/2006
VSTS HOL / TCL
 Hands on Labs
    DEV005 Streamlining your Development Process with Visual Studio 2005 Team System

 Chalktalks
    Building Quality In: Visual Studio Team System and Continuous Integrated Testing
         DEV TLC Theatre 6/14/2006 8:30AM-9:45AM
    Teamlook and TeamSpec in Context Modeling that Supports Visual Studio 2005
         DEV TLC Theatre 6/14/2006 5:30PM-6:45PM
    Modeling that Supports Visual Studio 2005
         DEV TLC Theatre 6/14/2006 5:30PM-6:45PM
    Code Generation and Model Execution from DSL Tools
         DEV TLC Theatre 6/15/2006 2:45PM-4:00PM
Resources
Technical Chats and Webcasts
http://www.microsoft.com/communities/chats/default.mspx
http://www.microsoft.com/usa/webcasts/default.asp

Microsoft Learning and Certification
http://www.microsoft.com/learning/default.mspx

MSDN & TechNet
http://microsoft.com/msdn
http://microsoft.com/technet

Virtual Labs
http://www.microsoft.com/technet/traincert/virtuallab/rms.mspx

Newsgroups
http://communities2.microsoft.com/
communities/newsgroups/en-us/default.aspx

Technical Community Sites
http://www.microsoft.com/communities/default.mspx

User Groups
http://www.microsoft.com/communities/usergroups/default.mspx
  Fill out a session
       evaluation on
       CommNet for
        a chance to
Win an XBOX 360!
           © 2006 Microsoft Corporation. All rights reserved. Microsoft, Windows, Windows Vista and other product names are or may be registered trademarks and/or trademarks in the U.S. and/or other countries.
The information herein is for informational purposes only and represents the current view of Microsoft Corporation as of the date of this presentation. Because Microsoft must respond to changing market conditions, it should not
                               be interpreted to be a commitment on the part of Microsoft, and Microsoft cannot guarantee the accuracy of any information provided after the date of this presentation.
                                             MICROSOFT MAKES NO WARRANTIES, EXPRESS, IMPLIED OR STATUTORY, AS TO THE INFORMATION IN THIS PRESENTATION.

				
DOCUMENT INFO
Description: Database Project for Lab Management document sample