Title: Microsoft Visual Studio Team Edition for Database Professionals VSTEDP
1Microsoft Visual Studio Team Edition for Database
Professionals (VSTEDP)
- Justin King (JustinKing_at_ssw.com.au)
2Agenda
- Overview History
- Database Development Life Cycle
- Creating a Project and Importing a Database
Schema - Defining New Database Objects
- Synchronizing Schemas
- Schema Comparison
- Data Comparison
- Generating Test Data
- Unit Testing Stored Procedures
31. Overview History
4History
- www.Red-gate.com
- Schema Compare
- Data Compare
- Refactor
- www.apexsql.com
- xx
5Overview
New!
Visual Studio Team Suite
SoftwareArchitects
SoftwareDevelopers
SoftwareTesters
DatabaseProfessionals
VisualStudioIndustryPartners
VisualStudioTeamExplorer
Application Modeling
Code Analysis
Performance Testing
Database Change Management
Infrastructure and Deployment Modeling
Performance Tuning
Manual Testing
Database Testing
Test Case Management
Database Deployment
Security Analysis
Unit Testing
Code Coverage
MSF Process and Guidance
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
6Product Overview
- Database Project System
- Schema and Script Versioning (SCC Integration)
- Schema Build Deploy
- Schema Compare
- Data Compare
- Database Unit Testing
- (Test) Data Generator
- Schema Refactoring
- T-SQL Editor with Query Execution
- Work Item and Process Integration with TFS
72. Database Development Life Cycle
8Database Development Life Cycle
Import database schema
SQLServerDatabase
Database Project Template
Database Project
Create New Project
SQL Script
Reverse engineer existing .SQL script files ()
9Database Development Life Cycle
Edit
Refactor
Compare
Database Project
Build
Deploy
Data Generation
Test
Compare
10Database Development Life Cycle
Import database schema
SQLServerDatabase
Build project
Database Project Template
Database Project
Create New Project
Deploy project
SQL Script
Reverse engineer existing .SQL script files ()
11How we do it at SSW
- Setup the DEV database (Import the schema from a
production database) - Create a baseline (Setup a TEST database to match
the imported database schema) - Schema Comparison
- Data Comparison
- Modify the schema within the development
environment (Add table, keys, stored procedures) - (SSW) Save .sql files
- Refactor Database Objects
- (SSW) Save .sql files
- Perform a Schema Comparison between development
and test databases - (Not at SSW) Script the changes
- (SSW) Use SQL deploy to run the update scripts
against the TEST database
12Continues
- Perform another Schema Comparison between DEV and
TEST databases to ensure there are no changes - Unit Testing
- Data Generation Plans
- (SSW) Use SQL deploy to run the update scripts
against the PROD database - Perform a Schema Comparison between TEST and PROD
databases
13Creating a Project and Importing a Database Schema
14Creating a Project and Importing a Database Schema
15Creating a Project and Importing a Database Schema
16- Defining New Database Objects
17Defining New Database Objects
18Synchronizing Schemas
19Synchronizing Schemas
20Synchronizing Schemas
21Generating Test Data
22Generating Test Data
Figure 15. The three main tables selected (with
related tables partially selected).
23Generating Test Data
Figure 16. Setting the Generator column to Data
Bound Generator
24Unit Testing Stored Procedures
25Unit Testing Stored Procedures
Figure 19. Choosing Pre-test, Test, or Post-test
26Summary
- Overview History
- Database Development Life Cycle
- Creating a Project and Importing a Database
Schema - Defining New Database Objects
- Synchronizing Schemas
- Schema Comparison
- Data Comparison
- Generating Test Data
- Unit Testing Stored Procedures
27All done Questions?
http//kingjustin.com